in a results table, matches the row header between the results table and data table, and searchs the data table array for a particular value, such as "Yes", and returns the column header for each instance where in the matching rows between the results and data tables, where a "Yes" populates within the table array.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Looking for an index array formula that..
- Thread starter freeb1893
- Start date
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 64,372
- Office Version
- 365
- Platform
- Windows
Duplicate to [url]http://www.mrexcel.com/forum/excel-questions/694275-need-formula-lookup-column-header-based-data-results-within-table.html[/URL]
Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per # 9 of the Forum Rules.
Any bumps, clarifications, or follow-ups should be posted to the linked thread.
Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per # 9 of the Forum Rules.
Any bumps, clarifications, or follow-ups should be posted to the linked thread.
Upvote
0
- Status
Similar threads
- Solved
- Solved
