IF or LOOKUP to return different value

[tpillow]

Hey ya'll I'm new here but you've been a great help to me before so I figured I'd give it a shot again.

Column A lists types of employees (managers, engineers, sales reps, etc.), each of which earns a seperate hourly rate. Column C lists hours worked, and Column D lists the total pay (Cx*Bx).

So column B is missing. Is there a way to generate the hourly rates in column B for each employee type in collumn A, i.e. if it's an Engineer, return $29, if it's a Technician, return $18, without an infinite set of True/Fasle conditions.

Please keep in mind that the attachment is a dummy list designed to illustrate the problem. The real thing has many more rows.

Thanks in advance....

[DonkeyOte]

Store the EE type & associated rate in a table and use a VLOOKUP in Column B.

eg

F1: Engineer G1: 29
F2: Technician G2: 18
F3: Site Specialist G3: x
etc... for all roles

then

B2: =IF($A2<>"",VLOOKUP($A2,$F$1:$G$100,2,0),"")

[tpillow]

That works, thanks a lot.

Just curious, is there a way to do that without creating a seperate table?

[DonkeyOte]

Depending on how many roles you have you could use an inline array constant, ie:

=IF($A2<>"",VLOOKUP($A2,{"Engineer",29;"Technician",18;"Site Specialist",12},2,0),"")

If you have lots a table is best... it's easier to adapt.
(the table need not be on the same sheet as your data of course)

[tpillow]

OK swell. Thanks a lot!

[martindwilson]

another way
=INDEX({30,25,28,40,50,18},MATCH(A2,{"Site Specialist","Sales Rep.","Engineer","Sales Manager","Consultant","Technician"},0))