We can use the Search function in Excel to find a value that equals a specified value, however it will return nothing if there are no values that exactly match the lookup value. Have you ever attempted to determine the closest value that is larger than or less than a certain amount, as shown in the screenshot below? In this tutorial, I'll show you how to use Excel formulas to get the closest number that is more or less than the lookup value.
Locate the Lowest Price More than
Select a blank cell for the lookup result, type
Hit Shift + Ctrl + Enter at the same time. Take a look at this image:
The range you want to locate value in is A1:B6, and the value you want to search for is E1.