jeudi 1 décembre 2016

How to get the value of another cell if the only addition to the referenced cell is "-LA" or "-LED'

So I have a full sheet of item numbers that need to be updated for quantities on a daily basis. There are many items that contain two accessories as different item numbers such as what is shown below: 1114
1114-LA
1114-LED

What I need to happen is for the value(quantity) of the two numbers with the "-LA" and "-LED" to equal the original item number's (ex. 1114) quantity. Some items have no other option and some only have one or the other, and some have both.

Any Ideas on how i could do this? The spreadsheet is several thousand numbers long.

Aucun commentaire:

Enregistrer un commentaire