I'm trying to do a lookup or vlookup (not sure which I should use) for the following scenario:
sheet 1:
Identifiers:
A
B
C
sheet 2 (Columns A / B)
A - 1
A - 2
A - 3
B - 1
B - 2
C - 1
C - 3
For sheet 1, I want to be able to return a "yes" or "no" if sheet 2 has a corresponding value of 3. In this example, A and C would return "yes" with B returning "no".
Thanks in advance.
Bookmarks