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