Closed Thread
Results 1 to 2 of 2

Formula Question - Value Lookup - Part 2

  1. #1
    Registered User
    Join Date

    Formula Question - Value Lookup - Part 2

    Since no response from Excel - general, reposting it here. I assume this will need a macro/VBA treatment !
    Hello Everyone,

    Pls refer to the following table.

    Name apple (y/n) laptop
    john y hp
    john y lenovo
    john y apple
    john y sony
    john y asus
    smith n lenovo
    smith n asus
    smith n hp

    For a name in the "Name" column, if you find the word apple in the "laptop" column, we need to substitute "Y" in "apple(y/n) column for all occurences of that particular name (in the above example "john"). If there is no occurence, we need to subsitute "N". How do we do this using formulae ?


  2. #2
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365

    Re: Formula Question - Value Lookup - Part 2

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


Closed Thread

Thread Information

Users Browsing this Thread

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


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