If Statement On Two Conditions
 

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

If Statement On Two Conditions
 

Try this:

=VLOOKUP(E5,L1:P5,MATCH(F5,L1:P1,0),0)

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
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

If Statement On Two Conditions
 

RK,

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

HTH,
Bernie
MS Excel MVP


"RoadKill" wrote in message
...
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

If Statement On Two Conditions
 

Assuming the table is in I12:M16

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

--
HTH

Bob

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

"RoadKill" wrote in message
...
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

If Statement On Two Conditions
 

Works perfect, thank you!

"Bernie Deitrick" wrote:

RK,

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

HTH,
Bernie
MS Excel MVP


"RoadKill" wrote in message
...
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

If Statement On Two Conditions
 

Works perfect, thank you!

"T. Valko" wrote:

Try this:

=VLOOKUP(E5,L1:P5,MATCH(F5,L1:P1,0),0)

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
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