vlookup in excel97

  Leepy Lee 20:39 19 Mar 07
Locked

I'm using vlookup to find data in another sheet.
If the target data is just a list of numbers, it works OK. But when the target cells contain formulas, e.g. =RIGHT(B5,4) then all I get is an error.

How do I tell excel to take the value in the cell rather than the formula?

Any help appreciated.

Cheers,
Lee

  VoG II 21:02 19 Mar 07

Can you post the full formula that you are using please?

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5