IF in formula

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

Help...I'm tired of trying different formulas and none are working...

I'm looking for a formula to do the following, with 9 employee names
possible in one cell, each employee, depending on who's name is typed in,
will multiply different cells for the answer.

If cell B2 would be "employee1" then take C2*E2*I24, if B2 would be
"employee2" then take C2*E2*I25, if B2 would be "employee3" the take
C2*E2*I26 and so on

Thanks for your input!!!
 
No IFs are required. Let's put a simple lookup table in Z1 thru AA9:

Mary I24
Alice I25
Judy I26
Mabel I27
Janet I28
Alicia I29
Becky I30
Susan I31
Kate I32

This gives the proper cell to use for any name.

then:

=INDIRECT(VLOOKUP(B2,Z1:AA9,2,FALSE))*C2*E2
 
Back
Top