Return Row title from existing Max formula

[Iain Clarendon]

Hi,

I am trying to return the row title from a max formula
I have data validation picking the month I want the max value to return from
Also want to return in a seperate cell the Item number.
I have tried =INDEX(A3:A14,MATCH(C18,Month_Year,0),MATCH(D18,Item_Data,0)) ctrl shift enter

Thanks for any help

Iain

[Jonmo1]

Here's a Non-Array formula you can use in D18
=MAX(INDEX(Item_Data,0,MATCH($C18,Month_Year,0)))

Then in E18, you can use
=INDEX($A$3:$A$14,MATCH($D18,INDEX(Item_Data,0,MATCH($C18,Month_Year,0)),0))

[mcmahobt]

Something like this?

Please Login or Register  to view this content.

[Iain Clarendon]

Thank you,
Works as planned

Cheers Iain

[Jonmo1]

You're welcome.