Lookup function - can it return the higher value?

  • Thread starter Thread starter Xipha
  • Start date Start date
X

Xipha

I am trying to use the VLOOKUP function, except if the value is not found I
want the function to return the value one higher than the lookup value,
instead of rounding down to the nearest value. Is there a way to do that?
 
Hi,

With your lookup table in A1 - B10 and the value to lookup in C1 try

=INDEX(B1:B10,
IF(ISNUMBER(MATCH(C1,A1:A10,0)),MATCH(C1,A1:A10,0),1+MATCH(C1,A1:A10,1)))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return value greater than in LOOKUP 3
LOOKUP 5
Returning Formatting on a Lookup 2
Lookup Question 4
How can I retain the formatting of the data in a lookup table? 1
LOOKUP and higher value 4
How to lookup with more than 1 value 6
Vlookup Function 1

Back
Top