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!

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Hours[/TD]
[TD]Role Name[/TD]
[TD]LSEA[/TD]
[TD]SEA1[/TD]
[TD]SEA2[/TD]
[TD]SEA3[/TD]
[TD]Tools[/TD]
[TD]PM[/TD]
[TD]GOV[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]SENIOR EA3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]LEAD SENIOR LEVEL EA[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]GOV[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]SENIOR EA3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]TOOL SPECIALIST[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]SENIOR EA3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

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