IF formula and INDEX(MATCH formula question

KarenTF

I have two sheets: a Program List sheet and a Program Map sheet. On the Program List sheet, there are columns including a severity level (# 1-5), a frequency (# 1-5), and an overall score. On the Program Map, it is set up as a color-coded visual to quickly evaluate the severity vs score. I want to be able to create a formula on the Program Map sheet to pull in the programs from the Program List sheet when specific criteria are met. For instance, if Score is >=25 AND severity is 5, then collect ALL programs that meet these criteria and pull the program names into the desired map area. And then I would proceed to create similar formulae to map the different combinations of score & severity to their appropriate areas on the map.

Can this be done with IF and INDEX(MATCH formulas?

Paul Newcome

Are you able to provide some manual mock-up example screenshots?

KarenTF

I was able to solve this using the JOIN(COLLECT formula on the Program Map sheet!