vlookup returns bad data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Post your formula, and where it is, so that we can better close in what's
happening over there ..
 
Post the formula you are using.

--
Regards

Roger Govier


"SelfTaught_InNeedOfPro"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top