Quote:
Originally Posted by CH Coffieid
I am using a vlookup to find a specific value in a 2 column array.
=VLOOKUP(E32,[B4]Resources!$A$2:$B$38,2,1). The problem is it returns the correct value sometimes and incorrect values at other times. Any suggestions?
|
Change the 1 at the end to 0.
1 (or TRUE) will make Excel look for a nearest match and will require the lookup array to be in ascending order. 0 (or FALSE) will ensure Excel looks for an exact match only.