vlookup returns bad data

  • Thread starter SelfTaught_InNeedOfPro
  • Start date
S

SelfTaught_InNeedOfPro

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.
 
D

Domenic

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!

SelfTaught_InNeedOfPro
 
M

Max

Post your formula, and where it is, so that we can better close in what's
happening over there ..
 
R

Roger Govier

Post the formula you are using.

--
Regards

Roger Govier


"SelfTaught_InNeedOfPro"
 
Top