Forum Discussion
Struggeling with multiple value drop down list - Indirect function
Hello! I work in a Warehouse, and we decided to move from Google Sheets to Excel web. I spend all day trying to figure out how to create drop down lists, but I got stuck. We have a three column cla...
See the attached version.
Wow! Where was the problem? Why couldn't I make it work?
Many thanks!! True savior!Your idea was correct. However. you used =$F$16 or something like that as formula in the data validation rule. The value of that cell was text. I simply changed the data validation formula to =INDIRECT(SUBSTITUTE(A2 & " " & B2, " ", "_"))
Hello, many thanks for your help, the truth is that this seems to work on Excel, but when I try to replicate it on Excel Web it doesn't work... it tells me some of the ranges can't be found... do you know why this could be happening? I think there is an error on the web code version...
Again, many thanks for your time!
