VLOOKUP Problem

Copper Contributor

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.

2 Replies

@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.

Spectacular, thanks for sharing.