Good afternoon all,

I am looking to use Xlookup in an If statement with and, but I'm struggling.

Data is below in columns A, B, C. I want to loop this and search a concatenated A&B, returning C, and if A&B equal 1 and 2, return a value. However, I don't think Xlookup is what I want necessarily, but am not wanting to give up on it yet.


A M022C58659 1
B M022C58659 1
C M022C58659 1
D M022C58659 1
E M022C58659 1
A M022C58659 2
B M022C58659 2
C M022C58659 2
D M022C58659 2
E M022C58659 2

=IF(AND((XLOOKUP(A2&B2, A:A&B:B, C:C)=1), (XLOOKUP(A2&B2, A:A&B:B, C:C)=2)), "Y")

Trying to do this without moving to VB as I'm very rusty with VB.

Thank you for any help.