Data Insertion - Quickest way

[Exceler]

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

[NBVC]

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.

[Exceler]

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

[NBVC]

Try:

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

copied down

[Exceler]

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

[NBVC]

It's actually part of LEFT(A2,6) which means extract the left 6 characters of A2...

[Exceler]

Thanks alot man! Appreciated!