Sumifs or alternative for a table

[danielpeam]

I'll do my best to phrase this - I have a table, see below.

I have a table similar to below, in cells A9 and B8, I want to be able to edit the names to any of the names in the table, and have it return the appropriate value.

E.g, If I change the names to Bob and Pete, it should show the value in D4. Does anyone know the best formula for this?

Pete
Bob 129

	A	B	C	D	E
1		Daniel	Pete	Bob	Rich
2	Daniel	121	134	123	453
3	Pete	12	345	432	439
4	Bob	200	129	152	879
5	Rich	657	764	777	666
6
7
8		Bob
9	Daniel	123

<tbody>
</tbody>

 

[VBA Geek]

Excel 2013/2016
	A	B	C	D	E
1		Daniel	Pete	Bob	Rich
2	Daniel	121	134	123	453
3	Pete	12	345	432	439
4	Bob	200	129	152	879
5	Rich	657	764	777	666
6
7
8		Bob
9	Daniel	123
Sheet1

Cell Formulas
Range	Formula
B9	=INDEX(B2:E5,MATCH(A9,A2:A5,0),MATCH(B8,B1:E1,0))

 

[danielpeam]

This is perfect - thanks