Depending dropdown in excel online

[Giuse2035]

Hello,

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!

Giuse

[#2]

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.