Find column header from a lookup in multiple rows and columns

[Peter Davison]

I have headers in cells F1 to N1
I have data in cells F2 to N1000
I want to search for a lookup entry that can appear in any cell in F2 to N1000 and it returns me the column header from the respective column

I've tried Index and match but just can't fathom it out.
Any thoughts would be really helpful.
Thanks you for your time.

 

[Fluff]

Will the value you want to lookup only occur once in F2:N1000, or can it occur multiple times?

 

[Peter Davison]

It can occur multiple times but always in the same column

 

[Fluff]

Ok, how about

=CONCAT(UNIQUE(IF(F2:N1000=P3,F1:N1,"")))

where P3 has the value you want to find.

 

[Peter Davison]

Fantastic, a new one on me.
Thank you for your help.

 

[Fluff]

You're welcome & thanks for the feedback.