Find value in multiple rows/columns

[sharky12345]

I'm trying to find a way I can identify a value where a column and row meet.

In this example, I am trying to find the value in the column where SHQ on the top row meets BP in the first column, the result I would expect to see is 24. Similarly, if I wanted to look for TT and HA I would expect the result to be 34.

My range currently looks like this (I have ExcelJeanie installed but for some reason it is not working so I've had to manually copy and paste);

[TABLE="width: 512"]
<tbody>[TR]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl64, width: 64"]HA[/TD]
[TD="class: xl64, width: 64"]TA[/TD]
[TD="class: xl64, width: 64"]BP[/TD]
[TD="class: xl64, width: 64"]SHQ[/TD]
[TD="class: xl64, width: 64"]KWH[/TD]
[TD="class: xl64, width: 64"]TT[/TD]
[TD="class: xl64, width: 64"]SC[/TD]
[/TR]
[TR]
[TD="class: xl64"]SC[/TD]
[TD="class: xl65"]28[/TD]
[TD="class: xl65"]26[/TD]
[TD="class: xl65"]34[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl65"]19[/TD]
[TD="class: xl65"]10[/TD]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl64"]TT[/TD]
[TD="class: xl66"]34[/TD]
[TD="class: xl66"]34[/TD]
[TD="class: xl66"]36[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]21[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]10[/TD]
[/TR]
[TR]
[TD="class: xl64"]KWH[/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]13[/TD]
[TD="class: xl65"]18[/TD]
[TD="class: xl65"]10[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]21[/TD]
[TD="class: xl65"]19[/TD]
[/TR]
[TR]
[TD="class: xl64"]SHQ[/TD]
[TD="class: xl66"]26[/TD]
[TD="class: xl66"]23[/TD]
[TD="class: xl66"]24[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]10[/TD]
[TD="class: xl66"]9[/TD]
[TD="class: xl66"]9[/TD]
[/TR]
[TR]
[TD="class: xl64"]BP[/TD]
[TD="class: xl65"]21[/TD]
[TD="class: xl65"]20[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]24[/TD]
[TD="class: xl65"]18[/TD]
[TD="class: xl65"]36[/TD]
[TD="class: xl65"]34[/TD]
[/TR]
[TR]
[TD="class: xl64"]TA[/TD]
[TD="class: xl66"]2[/TD]
[TD="class: xl66"]0[/TD]
[TD="class: xl66"]20[/TD]
[TD="class: xl66"]23[/TD]
[TD="class: xl66"]13[/TD]
[TD="class: xl66"]34[/TD]
[TD="class: xl66"]26[/TD]
[/TR]
[TR]
[TD="class: xl64"]HA[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]21[/TD]
[TD="class: xl65"]26[/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]34[/TD]
[TD="class: xl65"]28[/TD]
[/TR]
</tbody>[/TABLE]

I have tried all sorts of VLOOKUP and HLOOKUP without success if someone can give me a pointer?

 

[Peter_SSs]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1		HA	TA	BP	SHQ	KWH	TT	SC		SHQ
2	SC	28	26	34	9	19	10	0		BP
3	TT	34	34	36	9	21	0	10		24
4	KWH	16	13	18	10	0	21	19
5	SHQ	26	23	24	0	10	9	9
6	BP	21	20	0	24	18	36	34
7	TA	2	0	20	23	13	34	26
8	HA	0	2	21	26	16	34	28
Index Match

 

[lrobbo314]

Assuming your data is in A1:H8. =INDEX(B2:H8,MATCH("SHQ",A2:A8,0),MATCH("BP",B1:H1,0))

 

[sharky12345]

Guys, thanks so much - this has been driving me crazy all morning but it's now sorted!