Return value to right of LARGE()

A

Alaska_John

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Starting with two columns of numbers, I use LARGE() to return the 2nd largest number in the left column. What function can I use to return the value of the cell to the right of that 2nd largest number?

Thanks!

John
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Starting with two columns of numbers, I use LARGE() to return the 2nd largest
number in the left column. What function can I use to return the value of the
cell to the right of that 2nd largest number?

Thanks!

John
Suppose the numbers are in column A, rows 1-10, and you want the value from
column B:
=INDEX(B1:B10,MATCH(LARGE(A1:A10,2),A1:A10,0))

Or:

=VLOOKUP(LARGE(A1:A10,2),A1:B10,2)
 
A

Alaska_John

Works like a charm! Thank you, Bob, for taking the time to reply,

Sincerely,
John
 

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

Top