You say everything is fine and is as it should be for vlookup to work, but
vlookup doesn't work.

Simple logic will tell you that the first part of the statement is then
incorrect.

--
Regards,
Tom Ogilvy

"charlene leblanc" wrote in
message ...
OK I did the formula to replace the contents of both the lookup_value and
the
table_array columns with no change in the result. The range_lookup is a
text
value.

Charlene

"charlene leblanc" wrote:

It's worth a try, but I'm not sure what you mean by 'root data'. Using
the
documented syntax of

"VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)"

Do you mean doing a copy of the lookup_value column or the table_array,
or
the range_lookup? I guess I could do all three ....

Thanks,
Charlene

"Cyberindio" wrote:

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?