I have everything working except my last index formula. I need it to pull people's names from a list if they have ANY of the following values. Everywhere I search the index function, they only talk about adding more criteria in an AND way, not an OR way. Here's the current formula:
{=INDEX(ListNames,MATCH(1,(Value1=Area)*(Value2=Area)*(Value3=Area)*,0))}
This is supposed to index anything that matches all three values. I need it to match everything with ANY of the three values, and list multiple people as answers.
Bookmarks