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)
statman wrote, apparently expecting people to grok the reference:
But now I feel like I'm in a Godel, Escher, Bach story that has gone horribly wrong.
Now, I have to say, I even have the book but don't get the reference!! (Of course, I've only read parts of it; one of many like that, intellectually fascinating--to a point--but not enough to keep me going. Maybe after this I'll pick it up again.)
Yes, great book! I read it in the 80's. It did take me a couple of attempts to get all the way through it. đŸ™‚