Need help with "If/Then" Statements I think

[CSRUSS]

I am trying to auto-populate cells using IF/Then Statements (I think)

The following is a description of the sample table below:
- Hours (Number of Hours Worked)
- Role Name
- Role Code (LSEA, SEA1, SEA2, SEA3, Tools, PM, GOV)

Question: How do I link the hours for a specific Role name to the corresponding Role Code Column? I want to be able to change the Role Name and then it automatically adjusts the hours to the corresponding Role code.

Your help would be greatly appreciated!

Hours	Role Name	LSEA	SEA1	SEA2	SEA3	Tools	PM	GOV
16	SENIOR EA3				16
8	LEAD SENIOR LEVEL EA	8
16	GOV							16
8	SENIOR EA3				8
8	PM						8
8	TOOL SPECIALIST					8
16	SENIOR EA3				16

<tbody>
</tbody>

 

[Rick Rothstein]

Put the following formulas in the indicated cells and then copy them down to the end of your data...

C2: =IF(B2="LEAD SENIOR LEVEL EA",A2,"")

D2: =IF(B2="SENIOR EA1",A2,"")

E2: =IF(B2="SENIOR EA2",A2,"")

F2: =IF(B2="SENIOR EA3",A2,"")

G2: =IF(B2="TOOL SPECIALIST",A2,"")

H2: =IF(B2="PM",A2,"")

I2: =IF(B2="GOV",A2,"")

 

[CSRUSS]

Works perfectly!! Thank you very much!