Sep 09 2024 12:19 PM
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.
Sep 09 2024 01:00 PM
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.