I want to know if I should be able to do this as a Data Validity formula:
OFFSET(offsetFrom,C18-1,2,1,1)
I was expecting to get a one row dropdown with the value ‘Manage Events’ - which I get as a value if I use this:
OFFSET(offsetFrom,C18-1,2)
offsetFrom is a named one cell range which is a cell on another tab; I have tried changing the formula to use the cell reference but it still doesn’t behave as I expected.
This is part of a bigger scenario I was attempting but if I can’t use OFFSET in this way I need to rethink? Or is there another problem I have missed?
Thank youExampleTryingDependantDropdowns.ods