Aug 18 2020 12:31 PM
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
Aug 20 2020 02:45 AM
Not sure I understood correctly, perhaps you may using something like this for data validation list (=$K3#)
Aug 21 2020 03:56 PM
Aug 22 2020 12:11 PM
@Piplinson , you are welcome
Aug 26 2020 12:10 PM
@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.