CatyH
Board Regular
- Joined
- Jun 27, 2017
- Messages
- 84
- Office Version
- 365
I have a table in A1:D6 with values already entered (basically, index of each state having answered each question (or not) ).
I want to have user pick a question in G1.
Then what I need are the formulas to feed into G4:G6 that will return the matching state from column A when the value is found for the selected question.
I know it's something to do with Match and index and a nested index with one parameter set to zero to return an array, but I cannot make it work...
Thank you for your help in advance!
cat