Showing a cell based on another's value

[giggleguy]

Hi guys, I'm a little rusty with my Excel formulas and I'm currently making a spreadsheet that calculates the prices of stock and the surplus attached to it.

What I want is for there to be a "Winner" section underneath that displays the top three surpluses by amount and name. I already have a cell displaying the top three by amount, by using the formula:

=LARGE(G4:G10,1)

Where G4 to G10 are the surpluses.

What I can't seem to figure out is a formula to display the name of the item based on the answer from that formula (The formula is in cell C12), where the names are listed in A4 to A10.

If anybody could help, that would be fantastic. If you need more information, please just ask, and I can provide more.

 

[bolo]

Hi guys, I'm a little rusty with my Excel formulas and I'm currently making a spreadsheet that calculates the prices of stock and the surplus attached to it.

What I want is for there to be a "Winner" section underneath that displays the top three surpluses by amount and name. I already have a cell displaying the top three by amount, by using the formula:

=LARGE(G4:G10,1)

Where G4 to G10 are the surpluses.

What I can't seem to figure out is a formula to display the name of the item based on the answer from that formula (The formula is in cell C12), where the names are listed in A4 to A10.

If anybody could help, that would be fantastic. If you need more information, please just ask, and I can provide more.

Try

=index($A$4:$A$10,match($C$12,$G$4:$G$10,0))

regards

Bolo

 

[giggleguy]

Thanks, it worked like a charm!