vlookup in excel97

  Leepy Lee 20:39 19 Mar 2007
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 2007

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

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?