I have a table with 4 columns.
Col 1 has the numbers that I wish to search through, (This is in ascending order and is formatted as a general number).
Col 3 has text which I want to appear when the VLOOKUP returns an exact match.
I am using false
The problem is that VLOOKUP returns the answer sometimes but for some reason is not consistent.
Has anyone come across this problem before? and if so how could I resolve it?
This message was edited by barrettm on 2002-04-09 00:57
Col 1 has the numbers that I wish to search through, (This is in ascending order and is formatted as a general number).
Col 3 has text which I want to appear when the VLOOKUP returns an exact match.
I am using false
The problem is that VLOOKUP returns the answer sometimes but for some reason is not consistent.
Has anyone come across this problem before? and if so how could I resolve it?
This message was edited by barrettm on 2002-04-09 00:57