Hello!
I am attempting to create a formula using index/match that will return results on a list where there can be up to 6 matches. I have been able to do this however, if I have less than 6 (my max) match results my formula begins to give me results that are not a match. What I want is if my list is out of match for a blank to be the result in the cell.
This is the formula I am using: =INDEX('Quarterly Results'!$A$1:$A$,MATCH,($B$2, 'Quarterly Results'!$B:$B,0)...adding +1 to +6) in my subsequent cells (for reference they are on my first tab C4-I4 along with the B2 from the formula which is the cell my users will be making changes in - entering the market name (Quarterly results column B) to pull in store numbers (quarterly results column A).
Any help would be SO greatly appreciated!!
I am attempting to create a formula using index/match that will return results on a list where there can be up to 6 matches. I have been able to do this however, if I have less than 6 (my max) match results my formula begins to give me results that are not a match. What I want is if my list is out of match for a blank to be the result in the cell.
This is the formula I am using: =INDEX('Quarterly Results'!$A$1:$A$,MATCH,($B$2, 'Quarterly Results'!$B:$B,0)...adding +1 to +6) in my subsequent cells (for reference they are on my first tab C4-I4 along with the B2 from the formula which is the cell my users will be making changes in - entering the market name (Quarterly results column B) to pull in store numbers (quarterly results column A).
Any help would be SO greatly appreciated!!
