Forum Discussion
Xlookup with nested IF
Thank you in advance for your help. What I am trying to do is return a value (using Xlookup) but only if another value matches. Maybe I need to use Index/Match, but here's my example: Col A Col B...
=FILTER($D$1:$D$1000, ($A$1:$A$1000="Yes")*($C$1:$C$1000="Smith"), "")
or
=INDEX($D$1:$D$1000, XMATCH(1, ($A$1:$A$1000="Yes")*($C$1:$C$1000="Smith")))