Lookup Help

[Guest]

I am trying to look up UPC values in column B. If a UPC listed in Column B
is also listed anywhere in Column C, then I want to return 'Yes" in column D.
If not I want to return 'no". I am sure this is simple, but I can't figure
it out from Lookup help. Thanks!

example:

Column B Colum C Column D
77777 11111 YES
22222 77777 NO
55555 66666 NO

 

[carlo]

Hi jgundel

in Column D (i started with row1) you enter following formula:

=if(iserror(vlookup(B1,C:C,1,false)),"no","yes")

hth

Carlo

 

[Guest]

Hi,

Try this:

=IF(COUNTIF($C$1:$C$1000,B1)>0,"Yes","No")
copy down

HTH
Jean-Guy