software

What I am trying to do is match 2 lists to get a value. In other words in
sheet1 I have this:
a
1 address anywhere
2 address some where
3 adress who knows

In sheet 4 I have a lists of addresses and if anything in column a matches
the list in sheet 4 I want it to put return in the same row in column j.

so if 1a matches anything in the list in sheet4 it will put quot;returnquot; for a
value in 1j.

=IF(COUNTIF('Sheet4!$A1$A100,'Sheet1!A1)gt;0,quot;Return quot;,quot;No Returnquot;)

copy down, for further reading see:

www.cpearson.com/excel/duplicat.htm

--
Regards,

Peo Sjoblom

(No private emails please)quot;Smishquot; gt; wrote in message
...
gt; What I am trying to do is match 2 lists to get a value. In other words in
gt; sheet1 I have this:
gt; a
gt; 1 address anywhere
gt; 2 address some where
gt; 3 adress who knows
gt;
gt; In sheet 4 I have a lists of addresses and if anything in column a matches
gt; the list in sheet 4 I want it to put return in the same row in column j.
gt;
gt; so if 1a matches anything in the list in sheet4 it will put quot;returnquot; for a
gt; value in 1j.