Data Insertion - Quickest way

Exceler

New member
Joined
Jan 8, 2014
Messages
4
Reaction score
0
Points
0
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!

View attachment MB.xlsx
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
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.
 

Exceler

New member
Joined
Jan 8, 2014
Messages
4
Reaction score
0
Points
0
It wont be non-galaxy. So what would be the formula?
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

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

copied down
 

Exceler

New member
Joined
Jan 8, 2014
Messages
4
Reaction score
0
Points
0
It worked!! thanks!
By the way, what's 6 in (A2,6)?
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
It's actually part of LEFT(A2,6) which means extract the left 6 characters of A2...
 
Top