=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...
Thursday, November 6, 2014
Subscribe to:
Posts (Atom)