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...
As variant
=XLOOKUP( $G$2 & "=" & $G$3, C:C & "=" & A:A, D:D, "-" )
Thank you for this very helpful contribution! This worked for my issue with XLOOKUP with 2 criteria 👍