My goal is to see what SKU sold and associate the COST to it.
I have an excel document for orders we receive and the SKUs vary depending on what the customer purchases.
An example of one sku would be: XBONECC-RP-X1spRP-X1Splat-X1iS2ZHbkp-X1iS2ZHs-X1xMM-X1Pp-X1mRd-X1mPRtg-X1mRGb
I want to grab elements like "-XBONECC-" and make that populate a cell with $17. Then if the SKU also contains "-X1xMM-" then the value would be $40 in another cell.
Note: The SKU dynamically changes, so the location of the -X1xMM- for example can vary where it falls within the full SKU line.
Ideally the cells would show the value of that sku, then we would just do a =sum to get the total cost of the SKU.
Any help is greatly appreciated, thank you so much! Can't find anything related to this need.
Bookmarks