The formula approximates the values to the largest number smaller then the given number to give an approximate match. We can change the bin range if we want to have the smaller number larger then the given number for getting a match.
Formula to manage serial number in a filtered list.
Looking up values by VLOOKUP() formula
INDEX() and MATCH() with two criteria.
Category: Lookup and reference
Looks up values in a vector or array
LOOKUP(lookup_value, lookup_vector, [result_vector])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM