Data Validation with Multiple References

Saturn24

New member
Joined
Feb 18, 2014
Messages
1
Reaction score
0
Points
0
I am building a product configuration spreadsheet in Excel 2010 with rules based dependencies. I am attempting to create a data validation formula that will reference a previous cell with six possible entries and then result in two possible answers.

First set of choices:
ZDrive_0.125
ZDrive_0.25
Fast_ZDrive_0.50

Desired result:
4090u 4" Handling Upgrade Kit


Second set of choices:
ThinWafer_ZDrive_0.125
ThinWafer_ZDrive_0.25
ThinWafer_Fast_ZDrive_0.50

Desired result:
4090u 4" ThinWafer Handling Upgrade Kit

Any assistance would be greatly appreciated.
 
Last edited:
Top