vlookup not found

B

BadgerDave

My vlookup statement is not finding values that I can confirm exist in the
array. The problem has something to do with the format, I assume, because if
I re-key the searched item, it works. I'm looking up 4-digit numbers
produced from a report that is dumped into Excel. I've tried reformatting
the data to numeric, but that doesn't work.
 
A

Aladin Akyurek

Try to run Data|Text to Columns on the data you have dumped into Excel.
Othwerwise, experiment with:

=VLOOKUP(LookupValue&"",LookupTable,ReturnRangeIndex,0)
 
Top