You can try this Jon

=IF(COUNTIF(A1,RawData!A:IV)0,"exist","not exist")

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jon" wrote in message ups.com...
I have a workbook that has two sheets. The first sheet is called
'Objects' and the second sheet is called 'RawData'. The 'Objects'
sheet has values down the A column. There are about 4,000 rows. The
values are just simple strings.

In the 'RawData' sheet, I just have output of code from an entire
application. So basically, it is a bunch of text.

How can I find out if the string in A1 (then A2, A3, A4....) exists
anywhere within the 'RawData' sheet? If it does exists then I just
want to put a '***' (or any type of flag) on B1 (or B2, B3, B4...) in
the 'Objects' sheet, and if the string isn't in the 'RawData' sheet,
then leave cell B1 blank.

Thank You,
Jon Wetzel