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


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]Daniel[/TD]
[TD]Pete[/TD]
[TD]Bob[/TD]
[TD]Rich[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Daniel[/TD]
[TD]121[/TD]
[TD]134[/TD]
[TD]123[/TD]
[TD]453[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Pete[/TD]
[TD]12[/TD]
[TD]345[/TD]
[TD]432[/TD]
[TD]439[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Bob[/TD]
[TD]200[/TD]
[TD]129[/TD]
[TD]152[/TD]
[TD]879[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Rich[/TD]
[TD]657[/TD]
[TD]764[/TD]
[TD]777[/TD]
[TD]666[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]Bob[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Daniel[/TD]
[TD]123[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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