I'm spectacularly bad at getting Index/Match to work, and I'm not even sure those are the functions I need, so I'll just lay out my problem, and pray you geniuses can save me!
Not actually related to Orchestras, but seems like a good placeholder for what I'm actually working with!
Sheet1 (includes column headers)
Sheet2 (includes column headers)
Not actually related to Orchestras, but seems like a good placeholder for what I'm actually working with!
Sheet1 (includes column headers)
- Column B includes a list of Orchestras. There are many duplicates, and 500 rows in total
- Column D includes a list of members of each Orchestra (not actually relevant for formula, but included in explanation to aid understanding)
- Column E includes which Region the member is from (there are 3 different ones)
- Column G includes which Group each member is part of (there are 2 different ones)
Sheet2 (includes column headers)
- Column A includes the list of Orchestras from Sheet1, but without any duplicates (60 rows)
- Column B through G represent the 6 combinations. It's in these columns that I need a formula which I'd want to have display a Y or a N to indicate if that combination exists for each Orchestra.