+ Reply to Thread
Results 1 to 2 of 2

Excel Macro multiple find and enter appropriate entry in another Column

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Portsmouth
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel Macro multiple find and enter appropriate entry in another Column

    I want to find Client in Column A, and then if it finds Client it enters 'N/a - Client' in corresponding row in Column C. But as well as looking for client i want it to look for Intra (still in Column A), and similarly if it finds intra enter 'N/a - Intra' in corresponding row Column C..... basically do this code for multiple entrys. i thought of using OR command but it didnt work

    Thanks in advance

    Here is the current code:

    Sub phillips()
    [C1:C1000]=[if(search("Client",A1:A1000)=0,"","N/A - Client")]
    end sub

  2. #2
    Registered User
    Join Date
    06-29-2011
    Location
    MUMBAI
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    85

    Re: Excel Macro multiple find and enter appropriate entry in another Column

    you can try the following code
    Please Login or Register  to view this content.
    regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1