Lookup column header based on row and table data

[GPet18]

Hello - looking for an Excel whizz.

Trying to complete Cell J3 with a column header based on the player and their 'score' from the week.

I have tried a combination of LOOKUP with INDEX MATCH but not quite getting it.

Any help would be much appreciated. Many thanks!

 

[DanteAmor]

Hi and welcome to MrExcel!

Try the following formula. I added a couple of examples.

Dante Amor
	A	B	C	D	E	F	G	H	I	J	K	L
1	Player	Intro	Light	Adapted	Standard	Heavy	Overload		Player	Player 2	Player 5	Player 1
2	Player 1	900	1000	1150	1500	1700	2100		Score	1400	2000	100
3	Player 2	1100	1200	1250	1700	1900	2350		Score category	Adapted	Standard	Not Found
4	Player 3	1350	1400	1250	1850	2050	2500
5	Player 4	1250	1350	1450	2000	2250	2700
6	Player 5	1350	1300	1350	1950	2250	2700
7
Hoja3

Cell Formulas
Range	Formula
J3:L3	J3	=IFERROR(INDEX($B$1:$G$1,,MATCH(J$2,INDEX($B$2:$G$6,MATCH(J$1,$A$2:$A$6,0),),1)), "Not Found")

---------------------------
NOTE XL2BB:
For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[GPet18]

Thank you so much - that worked perfectly!!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.