Forum Discussion

statman's avatar
statman
Copper Contributor
Sep 16, 2022
Solved

Filter in Xlookup function

Hello, [Excel 365 v2208; Windows 10] I am trying to hurt my brain with this combination. Your help (to avoid the hurt) is appreciated. đŸ™‚ Situation: Table2 is 4 columns and 150 rows. I use FILTER...
excel
Formulas and Functions
office 365
  • mtarler's avatar
    mtarler
    Sep 16, 2022
    you could use the LET() statement and I recommend you try that statement out.
    =LET(subset,FILTER(Table2,(Table2[Col1]=50)*(Table2[Col2]=30),""),
    XLOOKUP($B$11,INDEX(subset,,3),INDEX(subset,,4),"",-1,1)
mathetes's avatar
mathetes
Silver Contributor
Sep 16, 2022
If you've got it working, no need. But for curiosity's sake, I'd sure love to see it in action, and your posting it would save my having to create it.

I like Matt Tarler's use of LET as well.
statman's avatar
statman
Copper Contributor
Sep 16, 2022
Yes, I do have it working. I might create a spreadsheet, but given that it's Friday afternoon, the odds are low. đŸ™‚

Thank you for the support.

Chuck

Resources