Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
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.
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.