If Statement On Two Conditions

[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 L15 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

 

[T. Valko]

Try this:

=VLOOKUP(E5,L15,MATCH(F5,L11,0),0)

 

[Bernie Deitrick]

RK,

=INDEX(L15,MATCH(E5,L11,False),MATCH(F5,L1:L5,False))

HTH,
Bernie
MS Excel MVP

 

[Bob Phillips]

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)

 

[RoadKill]

Works perfect, thank you!

RK,

=INDEX(L15,MATCH(E5,L11,False),MATCH(F5,L1:L5,False))

HTH,
Bernie
MS Excel MVP

 

[RoadKill]

Works perfect, thank you!

Try this:

=VLOOKUP(E5,L15,MATCH(F5,L11,0),0)