Finding Next Highest Value in LookupTable?

G

Guest

Hi,

I want to create a formula that would compare a calculated number (C13) and
compare it against the numbers listed in A1. If C13 doesn't doesn't match any
of the listed numbers then the idea is to settle for the closest but higher
number in A1 and return the corresponding info listed in B1.

So for example, if C13 is calculated as 12.22 then it should return "d2".

A1 B1
10.83 d1
13.82 d2
16.27 d3
18.47 d4

Thanks for any ideas/help.

Les
 
G

Guest

First sort your table by column A in descending order, then
=INDEX(B:B,MATCH(C13,A:A,-1))
will give d2.

Regards,
Stefi


„Les†ezt írta:
 
G

Guest

Worked like a charm! Thanks, Stefi.

Les

Stefi said:
First sort your table by column A in descending order, then
=INDEX(B:B,MATCH(C13,A:A,-1))
will give d2.

Regards,
Stefi


„Les†ezt írta:
Click to expand...
 

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

Index & Match from Other Sheets? 2
Finding certain value in a column 2
SUMMING UP ONLY ONES IN A LIST 1
Finding Smallest Value 5
Simple Formula Question 4
How to determine the value - 02Dec? 3
How to retrieve the value? 2
making sure a cell in an array is not duplicated 2

Top