mackensteff
Board Regular
- Joined
- Feb 9, 2010
- Messages
- 74
- Office Version
- 365
- Platform
- MacOS
Hello,
I am trying to match two criteria in a table and return a list of matching results. As a picture is worth a thousand words I included the table below. I am trying to match the items in the orange box to the items to the left and then get the results in the green box.
I have tried index and match, but I can only get a single item from that and I would like to return all possible matches.
Any help is appreciated!
Thanks
I am trying to match two criteria in a table and return a list of matching results. As a picture is worth a thousand words I included the table below. I am trying to match the items in the orange box to the items to the left and then get the results in the green box.
I have tried index and match, but I can only get a single item from that and I would like to return all possible matches.
Any help is appreciated!
Thanks
Last edited: