=IF(ISNA(VLOOKUP(A1,$B$1:$B$6,1,FALSE)), "No", "Yes")
A is a list,
B is a List
if Values in A are in the B List, have Yes in the third column...
A is a list,
B is a List
if Values in A are in the B List, have Yes in the third column...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment