Forum Discussion
johnhill750
Sep 09, 2024Copper Contributor
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 incor...
HansVogelaar
MVP
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.
johnhill750
Sep 09, 2024Copper Contributor
Spectacular, thanks for sharing.