 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / March 2008searching columns for the same value
I have a cloumn of values and I want to search another column of values and have a "yes" or "no" yeild if the value in column A is found in column B. If there a formula that can help me with this? Thanks Use COUNTIF() Let's say we want to know if the value in A7 is found anywhere in column B. In an un-used cell (in a column other than A or B) enter: =IF(COUNTIF(B:B,A7)>0,"YES","NO")  SignatureGary''s Student - gsnu200776 > I have a cloumn of values and I want to search another column of values and > have a "yes" or "no" yeild if the value in column A is found in column B. If > there a formula that can help me with this? > Thanks
|
Reply to this Message |
 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
|
©2008 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.