I have a spreadsheet (condensed version attached) where I am trying to return into Dashboard C14 and down all the results from rawdata (table) where week #=B2 (610) in dashboard and Dashboard type = C10 (eSpecials) in dashboard. I was able to return one result using this array formula:
MATCH($B$2&$C$10,RawData[Week '#]&RawData[DashboardType],0)
But I can't figure out how to make it return multiple results using this same idea. If necessary, I can add a column to rawdata where it combines the Week # and dashboard type together to match on. Any help is greatly appreciated!!
Expected Result: (C14:C17)
ES6C04
ES6C04
ES6C11
ES6C17
Bookmarks