Pulling a row of info if matched

[NikkiMc204]

Please can anyone help me

I have a simple table with a drop down option in cell A4 -
Average Hourly Salary,
Average Daily Salary,
Average Monthly Salary,
Average Yearly Salary

When a user choose the option i want in sheet 1, cells b4:g4, the matching figures for each grade from sheet 4, b3:b6.

i'm flunking this badly. SOS

 

[SunnyAlv]

Like This ?

Formula on Sheet Idiot 1 on B4

=FILTER('Idiot 2'!$B$3:$G$6,'Idiot 2'!$A$3:$A$6='Idiot 1'!A4)

Sheet Idiot 1

Sheet Idiot 2

 

[kevin9999]

You have a number of different Office versions listed on your profile, incase you're using something earlier than 365 you could use this instead:

Book1
	A	B	C	D	E	F	G
2	Costings	AO	EO	HEO	SEO	G7	G6
3	FTE Resource used	1	1	1	1	1	1
4	Average Monthly Salary	2614.253	3190.17	3862.088	5211.589	6790.757	8325.259
5	Cost for Resource
Sheet1

Cell Formulas
Range	Formula
B4:G4	B4	=SUMPRODUCT((Sheet4!$A$3:$A$6=Sheet1!$A4)*(Sheet4!$B$2:$G$2=Sheet1!B$2),Sheet4!$B$3:$G$6)

Cells with Data Validation
Cell	Allow	Criteria
A4	List	=Sheet4!$A$3:$A$6

 

[NikkiMc204]

Thank you Sunny & Kev, you are both geniuses, formulas worked, thank you so much.

 

[kevin9999]

Glad we could help & thanks for the feedback