I have a huge list of convoluted values that are detailed code for different pieces of PC hardware. a couple dummy examples would be
SPS-DRV HDD 750GB SATA
SPS BATT 6C 62WHR
SPS-DRV HDD 640GB
SPS BATT 13D 41WHR
and so on...
Now what I really need from this are simpler values I can use to bucket-ize these parts into larger categories.
So I need a formula that can say if cell X contains "HDD" then cell X+1 should display "Hard Drive" OR if cell X contains "BATT" then cell X+1 should display "Battery"
I have approximately 10 categories that I can identify through a contains clause such as BATT or HDD.
Is there a way to do this via excel formula or even VBA?