Forum Discussion
VLOOKUP Problem
How do I have the have the value entered into the "logical _test" cell be exactly as shown in the data set.
My data set has "21855.5" as the "pointer" in my data set. However when I enter an incorrect number ie 21855.6 in another sheet of the workbook the requisite data for 21855.5 is returned as the value if true.
The data set does not have a 21855.6 entered into it.
Specify FALSE as 4th argument of the VLOOKUP function:
=VLOOKUP(lookup_value, lookup_range, column_number, FALSE)
This instructs Excel to look for an exact match.
- Spectacular, thanks for sharing.
