Forum Discussion
Bug in Excel online - dependent drop down lists
hi everyone, I'm using dependent dropdown lists and they work fine in desktop, but in the browser the second list is not working (but weirdly the third is). Very frustrating as my client needs to s...
To my knowledge, Excel for the web does not support the XLOOKUP function. Excel for the web has a subset of functionality compared to the desktop version of Excel, and not all functions and features are available. As a result, the XLOOKUP function may not be available in Excel for the web.
You can maybe combine the INDEX and MATCH functions to perform a lookup.