Excel Formula help: getting a top ten list and corresponding data from the same row with it?

[adm210]

Excel Formula help: getting a top ten list and corresponding data from the same row with it?

So i have a list of Savings in USD, under column A. Each saving per cell in Column A is associated with an Action that caused that saving. So all the savings amounts in USD are in column A and each action associated with the saving is listed in, column B for example. My boss would like me to complete a top ten list associated with actions that have the highest savings. I know that to get the top ten savings - use a LARGE formula, but once I have all the top ten Savings in USD, how can I develop a formula to show the action, buyer and project buyer alongside the corresponding savings? My spreadsheet looks like this:

Column
A ,B ,C ,D titles, respectively:
Savings USD, Action, Buyer ,Project Leader

Rows
1: 17K ,Negotiation of lower price,Perkins ,Roberts
2: 2k, Decrease in exchange rate, Sharp, Johnson
3: 50k,Found New Supplier,Smith, Roberts
4 7k,Reduced Transportation costs, Perkins, Johnson
5: 10k ,Negotiation of Lower Price,Jones ,Stutts

But lets say there are a total of 500 rows data resembling the above, i need to get the top ten actions with the highest savings in USD, displayed on a separate spreadsheet.
So having just the the top ten list with the saving listed in NOT enough, i need the corresponding action, buyer and leader associated with the actions, and couple other info from cells in different columns, each associated with a different specific saving, all on a separate worksheet within the same workbook

 

[jmthompson]

Can you insert a helper column, populated with the RANK formula, then do vlookups on the rank #?

=RANK(B2,B:B)

=VLOOKUP(1,A:B,2,FALSE) & ", " & VLOOKUP(1,A:C,3,FALSE)