Results 1 to 7 of 7

Thread: Data Insertion - Quickest way

  1. #1

    Talking Data Insertion - Quickest way



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How to put brand names beside their products (if its a huge list of products). Quickest way please and through I know i can do it with sorting, alternative please.

    Thanks!

    MB.xlsx

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    If you can say that any iPhone is Apple, Galaxy is Samsung, and the rest are Nokia, then we can easily apply a formula... but if there are others (i.e. non-Galaxy branded Samsungs), then it would be more difficult. You would need a keyword table or something to lookup to find match.


  3. #3
    It wont be non-galaxy. So what would be the formula?

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IF(LEFT(A2,6)="iPhone","Apple",IF(LEFT(A2,6)="Galaxy","Samsung","Nokia"))

    copied down


  5. #5
    It worked!! thanks!
    By the way, what's 6 in (A2,6)?

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    It's actually part of LEFT(A2,6) which means extract the left 6 characters of A2...


  7. #7
    Thanks alot man! Appreciated!

Posting Permissions

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