How do I get value from header match

[kitsa]

Hi,
I'm not sure how I get value from header match e.g. I need a criteria to match header with a cell, if match want to get a value of a sum cell, how would I write a formula?

as per pic:
Column A is the criteria to match Row 1 (E1:J1)
Give me answer Row 9 (E9:J9) if match, answer to B2:B5

 

[kevin9999]

Book1
	A	B	C	D	E	F	G	H	I	J
1	Header Name	Qty		Date	Bob	Peter	Jones	Adam	John	Paul
2	Bob	228		1/02/2022	100	20	200	20	90	10
3	Peter	367		2/02/2022	50	56	360	3	50	10
4	Jones	771		3/02/2022	20	11	54	3	20	10
5	Adam	48		4/02/2022	11	30	66	4	10	1558
6				5/02/2022	12	80	15	6	200	158
7				6/02/2022	15	14	18	10	30	2569
8				7/02/2022	20	156	58	2	3	12
9				Total	228	367	771	48	403	4327
10
Sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=INDEX($E$9:$J$9,MATCH(A2,$E$1:$J$1,0))
E9:J9	E9	=SUM(E2:E8)

 

[kitsa]

Mate your a legend, works perfect.

Thanks Heaps

 

[kevin9999]

Mate your a legend, works perfect.

Thanks Heaps

Happy to help & thanks for the feedback