Return value to right of LARGE()

[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

 

[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)

 

[Alaska_John]

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

Sincerely,
John