I was wondering if perhaps you may be able to help after I have tried to search through multiple threads for an answer to no avail. I have a pretty simple Match Index formula that I am using It reads as follows “=INDEX('Tier 1-2'!B:B,MATCH(A1,'Tier 1-2'!E:E,0)”
However, my workbook has multiple sheets that I would like the formula to return from as well as opposed to the 1 sheet that it looks into currently. Note that each sheet is identical in its format but contains different data. (i.e. I would like for the formula to look into Sheet 'Tier 3’, ‘Tier 4’, ‘Tier5’ also as opposed to only the sheet ‘Tier 1-2’ as it currently reads.) I would like to refrain from building multiple “IF” functions to accomplish this so I was hoping perhaps that the forum may know an answer instead.
Thank you for all your help!
However, my workbook has multiple sheets that I would like the formula to return from as well as opposed to the 1 sheet that it looks into currently. Note that each sheet is identical in its format but contains different data. (i.e. I would like for the formula to look into Sheet 'Tier 3’, ‘Tier 4’, ‘Tier5’ also as opposed to only the sheet ‘Tier 1-2’ as it currently reads.) I would like to refrain from building multiple “IF” functions to accomplish this so I was hoping perhaps that the forum may know an answer instead.
Thank you for all your help!