software

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.

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

=VLOOKUP(LookupValueamp;quot;quot;,LookupTable,ReturnRangeInd ex,0)
BadgerDave wrote:
gt; My vlookup statement is not finding values that I can confirm exist in the
gt; array. The problem has something to do with the format, I assume, because if
gt; I re-key the searched item, it works. I'm looking up 4-digit numbers
gt; produced from a report that is dumped into Excel. I've tried reformatting
gt; the data to numeric, but that doesn't work.