Can you show a copy of the formula you are using? And it would also help to
describe your data layout - your post implies an earlier thread, but I don't
remember seeing it.

Pete

"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