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)
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)
=LET(subset,FILTER(Table2,(Table2[Col1]=50)*(Table2[Col2]=30),""),
XLOOKUP($B$11,INDEX(subset,,3),INDEX(subset,,4),"",-1,1)
- Thank you for the response. This does seem to work! I had not heard of the LET function. It's the assignment operator that I was looking for. Thank you!
I say that it seems to work because when I changed the formula the output didn't change. That's a good thing. 🙂
Thank you again.
