Depending dropdown in excel online

Copper Contributor



I hope to get some help here.


Does anyone know how to create a dependent drop down menu in Excel On Line ?

This set up should be replicated in multiple rows 


I have tried with the Offset, filter & xlookup and indirect but none works-

I mean they work in Excel app but then when uploading the file in sharepoint, the dependent drop down does not work or it is unreliable. 


Thanks a lot!


1 Reply

In my experience, Data Validation (which is what I assume you mean by Dropdowns) only works with spreadsheet ranges. Most professional Excel programmers will carry a Worksheet around - sometimes hidden from view - for only such purposes. Try to create a new Worksheet, insert your SPILL somewhere to create the dynamic list, give that SPILL a name and use that name in your Data Validation. Your best chance, really.