Use Index and Match to populate data

[eechristaylor]

I have a list of Job titles in column A, Column B is the hours required for that task. I want to populate the hours on that row that correspond with the Job title. This is what i want to return but I want everything under the title Column to populate from the hours in the B column.

Position					Hours	Project Manager Broadband	Deputy Project Manager	Communication Lead	GIS Lead
Project Manager Broadband	5​				5​	5​
Deputy Project Manager	8​				8​		8​
Communication Lead	5​				5​			5​
GIS Lead	6​				6​				6​

I was trying to use INDEX and MATCH combination but I can't get it to work properly. Any help would be appreciated.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Position					Hours	Project Manager Broadband	Deputy Project Manager	Communication Lead	GIS Lead
2	Project Manager Broadband	5				5	5
3	Deputy Project Manager	8				8		8
4	Communication Lead	5				5			5
5	GIS Lead	6				6				6
Details

Cell Formulas
Range	Formula
G2:J5	G2	=IF(G$1=$A2,$B2,"")

 

[eechristaylor]

Thanks, perfect, didn't think to keep it simple!

 

[Fluff]

You're welcome & thanks for the feedback.