I am still finding my vlookup will not return a value for some odd lines of
my data, even though I know that the data is there in the array. I have been
having issues with various formats, and am using vlookup(A1+0, ... or
vlookup(A1&"", ... to force the vlookup to search for number or text values,
and generally this works.

However, I still find some odd lines return an N/A even if I copy the cell
from the search list to the table array - and use =A1=D5 which returns TRUE
showing they are definitely the same.

So is there anything else that could be causing this error?

Thanks for reading...


"Tyro" wrote:

You can find out quickly if your values match. Suppose your lookup value is
in A1and your lookup table is in B1:C10 and you think the value in A1 should
match the value in B6. Try the formula =A1=B6. If that returns TRUE your
values match, if it returns FALSE, they don't

Tyro

"robs3131" wrote in message
...
Hi all,

Per the subject, vlookup is not working -- I thought it might be because
of
hidden values as the data was downloaded from a website (in Excel format
though), however, I used David McRitchie's TRIMALL macro, but the problem
remains.

I also used Chip Pearson's CellView Add-In which showed that there were no
special characters. I also used the =ISTEXT(A2) worksheet function to
validate that no cells are text (both source cells for the vlookup as well
as
the cells being looked up). Finally, I tried various different formats
(number, date, text), however, nothing can get it to work. Just to be
sure
that it should work, I copied one of the lookup values, went to the column
of
the sheet where vlookup was searching, and used CTRL+F to validate that
the
value was witing the search range.

Any idea on what the issue can be??

Thanks!
--
Robert