If works if you are looking up numbers because the result is a number. See
my previous post in this thread.

--
Regards,
Tom Ogilvy

"Cyberindio" wrote in message
...
When all else has failed for me, Charlene, I have done this.

Insert a new column next to your Vlookup root data column

enter this formula: =(A2&"")+0 (assuming your root data starts in cell A2)

slide a copy paste of the formula all the way down to copy your whole data
column

replace your root data with the special paste:values of the new column

Charlene, I don't have to tell you to back up your file before attempting
anything anyone recommends to you.

Don't ask me why this might work, but it has resolved my vlookup issues in
the past.

Peace



"charlene leblanc" wrote:

I have inherited two spreadsheets that are linked and a VLOOKUP in one
is
referring to a range in the other. The VLOOKUPs all work on the
existing
data but as when I add new data, bearing in mind the formatting of the
cells
and the order of the lookup range, those do not work. I get the #N/A
error.

Any ideas?