First, I would insert a blank column between A and B.

In B1 I would enter this formula:

=IF(ISNA(VLOOKUP(A1,$C$1:$C$100,1,0))=TRUE,"NOT DISTY","DISTY")

Of course, adjust the ranges (A1,$C$1:$C$100) and responses
("DISTY","NOT DISTY") to meet your needs. Copy this formula down your
range of data.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=469252