swatsp0p Wrote:
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
::
I used the above formula (FWIW I have to use semicolons instead of
commas) but the results are all \"DISTY\". :( Also, what is the
zero for in the VLOOKUP formula?::


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