If you're looking for an exact match, make sure that the range type is
set to 0 or FALSE. For example...

=VLOOKUP(H2,$A$2:$F$100,2,0)

Notice that the the last argument for VLOOKUP is set to 0.

Hope this helps!

In article ,
SelfTaught_InNeedOfPro
m wrote:

I have a 1000 row 6 column table I look up based on row 1. I only have data
up to row 850. The remaining bad rows are for future items to be added.
Unfortunately, when I try to fill in one of the blank rows with data, or if I
try to change an existing line item to something else, my results from column
3 come back 20 rows off. Exactly 20 rows, therein I thought might be a hint?
It doesn't always cause an error, but it does the majority of the time. Any
advice GREATLY appreciated.