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("Smith", IF(answer="Yes", name), value, "Name not found")This formula replaces names in the search array by FALSE if the other condition/s are not satisfied.
[Note: I have also introduced defined names because I treat direct references as qualitative errors, but that is just me]