Forum Discussion

Piplinson's avatar
Piplinson
Copper Contributor
Aug 18, 2020

Dynamic Array for multiple data validation - Variable Data Entry Cell

Hi all   I have a formula that works great provided that the data triggering the array is always input from the same cell (G3 in the formula below)   =SORT(FILTER($D$2:$E$35487,$D$2:$D$35487=G3),...
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 20, 2020

Piplinson 

Not sure I understood correctly, perhaps you may using something like this for data validation list (=$K3#)

 

  • Piplinson's avatar
    Piplinson
    Copper Contributor
    Aug 21, 2020
    Thanks. I got it to work. Phil
    • farmgirl2010's avatar
      farmgirl2010
      Copper Contributor
      Aug 26, 2020

      Piplinson I have a situation similar to the one that you describe and was wondering how you solved.  I struggle with getting the cell that provides the lookup value to be dynamic.  Your column G.  

       

      thanks in advance for any help.  

       

       

Resources