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

Unique Ref	Col1	Col2	Col3	Col4
ABCD	100	200	300	400
EFGH	200	300	400	500
IJKL	300	400	500	600
MNOP	400	500	600	700

<tbody>
</tbody>

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))