I just need to check with someone else. Does the webversion of 365 lack certain features that are available in Desktop copies of Excel? I’m trying to create a dependent drop-down value, but I keep getting error messages when I try to mess with the formula in data validation to allow it to cascade into lower rows automatically.

Every single tutorial I’ve seen and read has been for a Desktop version of Excel, so I’m starting to lose hope that it’s even possible for me to do it. All I want is a single layer of dependent drop-down that works on every row in a sheet. But getting it to work on every row is just proving impossible.

XLOOP UP.xlsx

If there’s a way to get the formula that’s set-up in B3, to work in every row below, but change the formula to B4 and so on – without moving the cell references for the tables. That’d be terrific. But I don’t think its possible on the web version of Excel.

​I just need to check with someone else. Does the webversion of 365 lack certain features that are available in Desktop copies of Excel? I’m trying to create a dependent drop-down value, but I keep getting error messages when I try to mess with the formula in data validation to allow it to cascade into lower rows automatically. Every single tutorial I’ve seen and read has been for a Desktop version of Excel, so I’m starting to lose hope that it’s even possible for me to do it. All I want is a single layer of dependent drop-down that works on every row in a sheet. But getting it to work on every row is just proving impossible. XLOOP UP.xlsx If there’s a way to get the formula that’s set-up in B3, to work in every row below, but change the formula to B4 and so on – without moving the cell references for the tables. That’d be terrific. But I don’t think its possible on the web version of Excel.  Read More

​