validation offset RRS feed

  • Question

  • Have a dropdown validation list on one sheet from [sheet] RefTables column O, working fine.

    However ... would like to drop-down from RefTables Column O, but have the values from RefTables Column Y populate the cell.   ** Column O is a unique value, Column Y is that value's "caption', ie removing redundancies like city name, etc.

    Is this possible?


     - Mik

    Tuesday, March 31, 2015 1:26 PM


  • That is not possible with Data Validation. You could use a formula in the cell next to the cell with the validation dropdown. For example, if the validation dropdown is in D2, you could enter the following formula in E2:


    Adjust the range O2:Y100 as needed.

    Regards, Hans Vogelaar (

    Tuesday, March 31, 2015 2:03 PM