I have a unique problem that I haven't seen anywhere on the boards, although i will keep looking. It involves data from the GFK database.
GFK sends me data weekly regarding product sell through, however their products codes are irritatingly different from ours.. in this way.
Where OUR product codes are written "LA32R81BDX", their product code for the same product will be written "SAMSUNG /LA 32R81BDX". The blank spaces are always random, and I had the epiphany of using the "trim" function but it leaves a blank space between the product code and doesn't remove the "Samsung /" at the front either.
What I can do is set up a list of Suppliers/Brands as a point of reference to pull out that information from the codes - to return that data to one cell, but how do I join the product code and remove the brand to be returned to another cell?
We have no idea :\ The data 100% has a / before the code begins, maybe this helps. I'm playing around in excel right now to try and get it to work. Maybe if I set up the supplier list I can have a sort of "Remove (concatenate("supplier",/) but this doesn't solve the pushing together of the rest of the word. A super "trim" would be awesome about now.
ANY help is appreciated I'll keep checking this page throughout the days.
edit***
On a side note, can a vlookup return part of the same cell? I think thats what I need. I have a supplier list which looks up that supplier (with a wildcard following if possible) so like "vlookup("sunbeam*",$a$1:$b$5, (in this part do the squish together of everything after the /). Dunno if thats possible.
Bookmarks