Sep 07 2019 04:39 AM
I have a table set up that has a drop down list referencing different rows in another tab. Say the list is referencing row 4, I need the cells below it to automatically change to show row 4.
The trickier part of this is that if someone were to enter $30,000 into C4 in the image above, I need it to automatically update cell DP2 in the other sheet to reflect $30,000.
Any help is greatly appreciated.
Sep 07 2019 08:32 AM
@ineedhelp , I guess the same question as here https://techcommunity.microsoft.com/t5/Excel/Formula-help-Drop-down-list/m-p/842387/highlight/false#...
Sep 07 2019 08:34 AM
@Sergei Baklan Yes, same question. Just trying to get it figured out