vlookup returns bad data
 

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.

vlookup returns bad data
 

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.

vlookup returns bad data
 

Post your formula, and where it is, so that we can better close in what's
happening over there ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SelfTaught_InNeedOfPro" m
wrote in message ...
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.

vlookup returns bad data
 

Post the formula you are using.

--
Regards

Roger Govier


"SelfTaught_InNeedOfPro"
m wrote in message
...
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.