Hlookup & Large function

[Gallinski]

Hi all,

I'm trying to work out a formula for a Hlookup and a Large function in one.

Sheet 1 Example.
Columns A1:M1 are titled - Item, Jul-Jun.
Rows A2:A50 are items.
B2:M50 = item figures per month

Sheet 2 example
B1= Month - this will change and as such i need the below results to change.
A2:A11 needs to be results for top 10 figures for that month.
B2:B11 will be the index and match formula for the itemcoloumn on sheet 1. This bit i know.

So i guess the formula needs to do a hlookup to find the month and then Large the top 10 figures in the required column.

Thanks
Matt

[DonkeyOte]

You can use a LARGE with an embedded INDEX

Please Login or Register  to view this content.

Above assumes you will always have min of 10 items, if not you would need to add a pre-emptive COUNT test to avoid error where k exceeds item count.

[Gallinski]

Thanks

Solved.