Need SKU to represent a $$ Amount

[iicanceii]

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.

[FlameRetired]

Hi, iicanceii,

Welcome to the forum.

Is there any clue RE: the location of the sub-string within the SKU?

It would be best if you would upload an Excel workbook file directly to the forum. Include just enough information to get the idea across. 10 to 20 rows is usually sufficient. Be sure to desensitize all data.

If you are not familiar with how to upload a file here:

• click FAQ at the top of this page,
• under Board FAQ click Reading and posting messages
• then click Attachments and images
• You will find instructions on how to do this.

[iicanceii]

Thank you I will repost this article with more data.

[FlameRetired]

Cross posted here:

http://www.mrexcel.com/forum/excel-q...24-amount.html

Please check Forum rules to see why this is discouraged.

". Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed."

Thanks.