Forum Discussion

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),...

Piplinson

Copper Contributor

Aug 21, 2020

Thanks. I got it to work. Phil

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.