First of all, I appreciate the help I receive from this forum - It's a great tool I get to use for work and I'm happy to learn from you all!
I am trying to help someone with updating their inventory information quicker.
I have the vendor's pricing from their excel sheet organized like so
"Design" "Color" 9x12, 10x16, 13x18, etc....
ABC RED 500 600 800
Blue 500 600 800
Essentially, I have Product Codes based on design and size. all the colors are the same prices. They also give me product code info in another column...
So my Excel sheet, I have product code in one column
(ABC.0912 To represent a 9x12 sized item of ABC design)
Like so
Product code Price
ABC.0912 500
ABC.1016 600
ABC.1318
So right now I'm manually entering....I would index it but they don't really line up right, and we don't carry all the products.
So I'm wondering if there's a way to somehow drag the prices into the data correctly without manually doing it? I'll eventually re-organize everything probably if it can't be done.
I thought maybe Fuzzylookup module? But I realized I can fuzzylookup the correct Column (ABC), but couldn't get a connection between the 9x12 column name and the .0912 product code.
Can I somehow search In one column for a code, and then in turn search the row and spit out the corresponding crossing point?
Bookmarks