Forum Discussion

johnhill750's avatar
johnhill750
Copper Contributor
Sep 09, 2024

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.

  • johnhill750 

    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.

Resources