Need vlookup or hlookup formula to populate cell

[Rock5150]

Hello all

I have data below (sorry i can't use the xl2bb file format on my work computer) where i need the xxx cells below populated with the single number. I want to be able to add names on the right for whatever pairing i desire and show the number. The names should be able to be looked up regardless if i choose the name horizontally first or vertically. I guess it won't matter as its finding the 'coordinate'

So on the right Bea Baker and Dave Morris should populate "67". Is there a formula i can put in the cells that have the 'xxx' in there?

Just assume the first column you see is "A" and the xxx data is column "K"

Then the first row of data is row '1' down to row '6'.

If you need the xl2bb file to make it easier, let me know and i'll have to download offline.

	Bea Baker	Tony Brister	Dave Morris	Jerry Hill	Mike Archuleta
Bea Baker		62​	67​	65​	63​			Bea Baker	Dave Morris	xxx
Tony Brister	62​		69​	66​	65​			Dave Morris	Jerry Hill	xxx
Dave Morris	67​	69​		72​	72​			Mike Archuleta	Tony Brister	xxx
Jerry Hill	65​	66​	72​		74​
Mike Archuleta	63​	65​	72​	74​

 

[Rock5150]

Ham and Egg 11.29.2022 Formula.xlsx
	I
10
Sheet1

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H	I	J	K
1		Bea Baker	Tony Brister	Dave Morris	Jerry Hill	Mike Archuleta
2	Bea Baker		62	67	65	63			Bea Baker	Dave Morris	67
3	Tony Brister	62		69	66	65			Dave Morris	Jerry Hill	72
4	Dave Morris	67	69		72	72			Mike Archuleta	Tony Brister	65
5	Jerry Hill	65	66	72		74
6	Mike Archuleta	63	65	72	74
Sheet3

Cell Formulas
Range	Formula
K2:K4	K2	=INDEX($B$2:$F$6,MATCH($I2,$A$2:$A$6,0),MATCH($J2,$B$1:$F$1,0))