Forum Discussion
INDEX Multiple Match
Hi all, I am having a bit of a struggle finding the right way to exclude an Index hit already found. Due to the nature of the work I am doing, I an unable to share the exact file. The code to look...
Hi! Unfortunately, I have to tell you that MATCH(), just like XLOOKUP(), VLOOKUP() or XMATCH(), always produces only the first hit. The good news is that with FILTER() from Excel 2019 we have a function that can do this.
Your formula should read:
=FILTER(C:C,(B11=FILEPATH!$W:$W)*(D11=FILEPATH!$A:$A),"")