Forum Discussion

Giuse2035's avatar
Giuse2035
Copper Contributor
Feb 14, 2023

Depending dropdown in excel online

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

Excel for web
Formulas and Functions
  • ecovonrein's avatar
    ecovonrein
    Iron Contributor
    Feb 14, 2023

    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.

Resources