0
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.
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
By signing in/up, you agree to the Terms of Use and Privacy Policy.
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
0
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.