can u please explain me in lil detail.
i'll be very thankful :)

I thought I had. You have a list of names in column A of sheet 1 and another
list in a1 - a200 of sheet 2.

put my formula in B1 of sheet 1 and fill down. If any name appears in both
lists column B of sheet 1 will say 'THERE' otherwise column B will be blank.

Mike

"harveen" wrote:

On Feb 10, 11:59 pm, Mike H wrote:
Hi,

Lets say your list on sheet 1 is in column A and your list on sheet 2 is in
A1 - A200.
Put this in b1 of sheet 1

=IF(COUNTIF(Sheet2!$A$1:$A$200,A1)0,"There","")

Double click the fill handle and it will fill down as far as there are data
in column A anf if a site exists in sheet 1 and sheet 2 it will be marked
"There"

Mike

"harveen" wrote:
hello,

i have a list of 1000sites in excel sheet 1....and there is a list of
250sites in excel sheet 2.....
i have to find these 250sites in that list of 1000sites..

please help..
i'll be very thankful

Regards
Harveen :)

Thankyou very much....
but where should i add this =IF(COUNTIF(Sheet2!$A$1:$A$200,A1)
0,"There","")

can u please explain me in lil detail.
i'll be very thankful :)