Thanks Bob,

Using the "@" in the text function is new to me. Definitely something I can
use in other places.



"Bob Phillips" wrote:

Sounds like Prices key column is text. Fix that or use

=VLOOKUP(TEXT(C22,"@"),Prices,2,FALSE)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ATIHelp" wrote in message
...
I've got a very simple Vlookup function that is giving me a problem. I am
trying to find a match to a number, but can only get the match to work if
I
enter an apostrophe (') before the number (found in C22) and make it a
text.
I've checked that both the source cell and the searched cells are
formatted
to identical number format.

=VLOOKUP(C22,Prices,2,FALSE)

"Prices" is a sheet in a second externally linked workbook.

Thanks