Forum Discussion
Struggeling with multiple value drop down list - Indirect function
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!The workbook word OK for me in Excel Online, but perhaps there are exceptions.
Please tell us which ranges cannot be found
Hey, many thanks for your solution, the truth is that this works on excel, but when I try to take it to excel web it doesn't work... it tells me some of the ranges can't be found... any other possible solution?
Once again, thanks a lot for your time!