excel question - re: returning "top 10" table

[zimu]

hey guys,

some excel help please - hopefully quite easy...

so i have a table 1 which shows a list of items in column 1, and price in column 2.

i'm building a table 2 which should show top 10 priciest items. the price is easy to do, i've just done a =large(table1column2,1) for priciest, =large(table1column2,2) for 2nd priciest etc etc. so now i have the top 10 prices.

but how do i show the corresponding items in the first column of table 2? (the 2nd column already shows the prices, in ascending order).

can't use vlookup as my table1 isn't sorted in ascending order, plus the price is not in the first column...

 

[mayest]

You need to use the Index() and Match() functions. Use Match() to find the position of the item, probably using the Large() function as you mentioned. That will tell you that an item is, say, the 32nd in the list of prices. Then use the Index function to return the item name from the same position in the first column. Match() will be nested within the Index() function.