Giordano Bruno
Well-known Member
- Joined
- Jan 7, 2007
- Messages
- 1,345
I have a list of 20 items in the first dropdown menu. One of them is "ABC" I have named the sub group range associated with the items as "ABC" using an offset formula, something like "=OFFSET(Sheet3!$A$11,0,0,5,1)". If I put the Data Validation List Source as = ABC, then I get the required sub group in the drop down. If I use =INDIRECT(A1) and cell A1 has "ABC", I get nothing. If I define the name ABC directly as a range (i.e. not using an offset formula) I get the required sub group. Is there a workaround which will let me use both the Offset formula for the name and the Indirect formula for the reference?