Index Match based on two criteria from multiple columns
I am trying to set up a sheet reference based on two criteria (Center and Department). I have tried the index/match and that did not work, so I tried multiple variations of the index collect-- but that did not work either.
See image for the sheet i want to populate the data and the reference sheet that I have the data stored.
Ideally, it would function like this-- form user selects Center and Department and based on those columns, the correct people are populated.
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!