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:
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:
|
Desired result: 4090u 4" ThinWafer Handling Upgrade Kit Any assistance would be greatly appreciated. |
Last edited: