Index Assistance

[kassy]

Hello


I am trying to create a formula using multiple criteria that will look at a certain row of data, fix the max number and return the box quantity to me.

To further clarify what I am talking about, with the excel sheet I've attached I want it to look at the multiplier sheet, pull "apple", look at B3:AT3 and determine the highest number and return the box quantity from B2:AT2

I tried using INDEX(Multiplier!A3:A7,MATCH(Sheet1!A3,MAX(Multiplier!B3:AT3,Multiplier!B2:AT2)))

Thanks!

[NBVC]

Try:

=MAX(INDEX(Multiplier!$B$3:$AT$7,MATCH(A3,Multiplier!$A$3:$A$7,0),0))

if you are looking for the header numbers in row 2, then try:

=INDEX(Multiplier!$B$2:$AT$2,MATCH(MAX(INDEX(Multiplier!$B$3:$AT$7,MATCH(A3,Multiplier!$A$3:$A$7,0),0)),INDEX(Multiplier!$B$3:$AT$7,MATCH(A3,Multiplier!$A$3:$A$7,0),0),0))

[kassy]

The formula you have works except it does not retrieve the box Q in B2:AT2

[NBVC]

Sorry,

I realized that, please see my post again, I revised it.