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...
=XLOOKUP(1,($A$1:$A$2="YES")*($C$1:$C$2="SMITH"),$D$1:$D$2) In This Formula i Had Used Lookup Value as 1 and in Lookup Array i had used ($A$1:$A$2="YES")*($C$1:$C$2="SMITH") this will give result in 0,1,0,1 format and where value is match with 1 , Xlookup will go to same row but column D and give you the result, in Place of Smith you can use Cell Ref