VLookup Help on row headers rather than col_num

[JONTYH26]

Hello

Newbie so please bear with.

So, I want to pull a Value from a table using the lookup based on data in column A of a new sheet. I need to use the header rows of the table to find my Value as the number of columns will differ but the row header will not change. For example
[TABLE="width: 500"]
<tbody>[TR]
[TD]Unique Ref[/TD]
[TD]Col1[/TD]
[TD]Col2[/TD]
[TD]Col3[/TD]
[TD]Col4[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]300[/TD]
[TD]400[/TD]
[/TR]
[TR]
[TD]EFGH[/TD]
[TD]200[/TD]
[TD]300[/TD]
[TD]400[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]IJKL[/TD]
[TD]300[/TD]
[TD]400[/TD]
[TD]500[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]MNOP[/TD]
[TD]400[/TD]
[TD]500[/TD]
[TD]600[/TD]
[TD]700[/TD]
[/TR]
</tbody>[/TABLE]

I need to get the amount under Col2, with Basic as the name, by using the Unique Ref. A vlookup would work fine but if I want to paste new data over this, the value I need might be in Col3 but the coulmn Header, Basic, will still be the same.

Any insight will be greatly appreciated.

 

[Fluff]

Something like

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K
1	Unique Ref	Col1	Col2	Col3	Col4					EFGH
2	ABCD	100	200	300	400					Col3	400
3	EFGH	200	300	400	500
4	IJKL	300	400	500	600
5	MNOP	400	500	600	700
Sheet2

Cell Formulas
Range	Formula
K2	=INDEX($B$2:$E$5,MATCH(J1,$A$2:$A$5,0),MATCH(J2,$B$1:$E$1,0))