If Statement On Two Conditions

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

RoadKill

Okay, I need to calculate a total based off of two conditions. I am assuming
their is a way to do it via table, which I am unfamilar with. Is there an
easy way to do this example below? Maybe breaking it up into two calculations?

Essentially, if an individual has E5=Platinum and F5=Copper, then they would
achieve a score of 175.

The Table below would be in L1:P5 of the same sheet.

Platinum Gold Silver Copper
Platinum 350 300 225 175
Gold 300 225 175 150
Silver 225 175 150 100
Copper 175 150 100 75

Thank you
 
RK,

=INDEX(L1:P5,MATCH(E5,L1:P1,False),MATCH(F5,L1:L5,False))

HTH,
Bernie
MS Excel MVP
 
Assuming the table is in I12:M16

=INDEX(I12:M16,MATCH(E5,I12:I16,0),MATCH(F5,I12:M12,0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top