madmathsman
New Member
- Joined
- Sep 29, 2023
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
Hi
Have a 2 way data table, example in pic, and want to create a "search" function where you can enter a row title and it outputs the column title if that title has data in.
Eg in example, if you enter "Mon" in search it would output: Maths, Eng on seperate rows.
Any help or advice welcome
Thanks
Have a 2 way data table, example in pic, and want to create a "search" function where you can enter a row title and it outputs the column title if that title has data in.
Eg in example, if you enter "Mon" in search it would output: Maths, Eng on seperate rows.
Any help or advice welcome
Thanks