Hi guys, facing some mistery here, if would be okay to ask you take a look.
I'm using this formula =OFFSET($B$8:$B$10,0,MATCH(G3,$C$7:$E$16,0)) to help filter data in H3 based on what is selected in G3. This formula works perfectly in another file I grabbed it from but it does not work in a file I'm trying to replicate in the exact same way? Out of ideas, and frustrated...
Any suggestions? No arrays please.
https://www.excelforum.com/attachmen...1&d=1559736737 [EXCEL]
2019-06-05_1511.png
Bookmarks