Forum Discussion
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...
- 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)
Hmm, after posting, I found an error in the formula. I fixed it in the post and then in the spreadsheet. It seems to have worked. I am verifying.
What do you think? Should it have worked? I didn't post a sample spreadsheet. If that's necessary, then I can create one.
What do you think? Should it have worked? I didn't post a sample spreadsheet. If that's necessary, then I can create one.