LOOKUP ?

[Guest]

Hi,

In column A I have a list of products
columns B through to W contain other data
X contains growth rates for each product

In a separate sheet, I need to have a list of the top three growth products.
I have worked out how to get the values using the LARGE function.

My question is, how do I get the corresponding product name ? The only way
I can think of is to copy the product names into column Y and use a lookup
but this is a bit messy as I will be updating the report on a monthly basis.

I can't change the column order as there is a pivot involved. Is there a
simple function I could use ?

Thanks in advance for any assistance.
Pete

 

[Earl Kiosterud]

Pete,

Simple function? Not that I'm aware of, unless you wrote it as a UDF. You
need to use LARGE to find the largest three in the x column, then MATCH to
find out where they are in the column, then INDEX to get to the
corresponding values in column A.

=INDEX($A$2:$A$5,MATCH(LARGE($W$2:$W$5,1),$W$2:$W$5,0))

 

[Guest]

Thanks Earl !

That's exactly what I was looking for.

Regards
Pete