Results 1 to 1 of 1

Thread: Data Validation with Multiple References

  1. #1

    Data Validation with Multiple References



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 by Saturn24; 2014-02-18 at 09:29 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •