Dynamic Array for multiple data validation - Variable Data Entry Cell

[Piplinson]

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

G3 has a drop down field from which a selection is made. The selection then triggers the dynamic array which allows for a conditional drop down to appear in another cell from which I can then select and populate. I am using =INDEX($J$3#,,2) - to get the conditional dynamic dropdown. 

I want this same functionality to be available as an option in cell G4, G5 etc (which has the same drop down) 

In theory I can create multiple arrays and change the 'G' value each time but i will have thousands to create and so was looking for a dynamic solution. How do I make the array variable point to whichever the active G cell is at the time?

Any ideas? I am not skilled enough to do this in VBA.

Pip

[#2]

@Piplinson 

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

[#3]

Thanks. I got it to work. Phil

[#4]

@Piplinson , you are welcome

[#5]

@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.