Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

I am trying to match 2 lists

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Smish - 18 Dec 2005 20:17 GMT
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 "return" for a
value in 1j.
Peo Sjoblom - 18 Dec 2005 20:27 GMT
=IF(COUNTIF('Sheet4!$A1$A100,'Sheet1!A1)>0,"Return","No Return")

copy down, for further reading see:

http://www.cpearson.com/excel/duplicat.htm

Signature

Regards,

Peo Sjoblom

(No private emails please)

> What I am trying to do is match 2 lists to get a value. In other words in
> sheet1 I have this:
[quoted text clipped - 8 lines]
> so if 1a matches anything in the list in sheet4 it will put "return" for a
> value in 1j.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.