 |
 | 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 / Worksheet Functions / May 2008Lookup text in 1 column and note it in another
How do I find certain text in one column and note it in another. Example: Column P has Title and Regular in it. I want to note each time Title is found and note it with an X in column B. Column B Column P X Title Regular Regular X Title Thanks for your help. Nordic =IF(P2="Title","X","") copy down  SignatureRegards, Peo Sjoblom > How do I find certain text in one column and note it in another. > Example: Column P has Title and Regular in it. I want to note each time [quoted text clipped - 7 lines] > Thanks for your help. > Nordic |
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.