IF AND statement with cell range
I am trying to compare 2 cells against a range to determine if there is a
match:
Col A Col B Col C Col D
MARY BROWN TED SMITH
TED SMITH
BOB JONES
I'm using =IF(AND(C3=$A:$A,D3=$B:$B),"YES","NO") but it's obviously wrong
because I'm getting "NO" when it should return "YES". What am I doing wrong?
|