I need help creating an index match formula that will pull in multiple rows of data if they fit the criteria.
I am looking for a formula that would enable me to pull in multiple rows of information if they fit the criteria of "location" and "action type" from the master sheet as displayed in the yellow boxes on the Location 1 sheet.
Index Match Question.xlsx
I have managed to create an Index/Match formula that looks at location:
=INDEX('Master Sheet'!$A$1:$E$103,SMALL(IF('Master Sheet'!$A$2:$A$103='Location 1'!$C$1,ROW('Master Sheet'!$A$2:$A$103)),ROW(1:1)),COLUMN('Master Sheet'!A:A))
BUT, I am unable to add in the next criteria "Action Type".
Can you please help me and provide a formula that will enable me to do this.
I have attached the spreadsheet to this post.
Any questions please ask!
Thanks in advance!
Bookmarks