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.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…