none
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?

    Thanks,

     - Mik

    Tuesday, March 31, 2015 1:26 PM

Answers

  • 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:

    =IFERROR(VLOOKUP(D2,RefTables!O2:Y100,11,FALSE),"")

    Adjust the range O2:Y100 as needed.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Tuesday, March 31, 2015 2:03 PM