Rayne
asked on
Data Validate Source
Hello,
A data validation that happens off the list of data in sheet “sourceMySource”.
The sheet SourceMySource will have data changing but I need the data validation to pick up the driver options from the [ALL ] range and the indirects of the [All] values correctly?
I used these:
=OFFSET(INDIRECT(C4),0,0,C OUNTA(INDI RECT(ADDRE SS(1,COLUM N(INDIRECT (C4)))&":" &ADDRESS(6 5536,COLUM N(INDIRECT (J1))))),1 )
=OFFSET(INDIRECT(VLOOKUP(C 4,LookupLi st,2,0)),1 ,0,COUNTA( INDIRECT(V LOOKUP(C4, LookupList ,2,0)))-1, 1)
But none are helping…
How to do that?
EEQs22.xlsx
A data validation that happens off the list of data in sheet “sourceMySource”.
The sheet SourceMySource will have data changing but I need the data validation to pick up the driver options from the [ALL ] range and the indirects of the [All] values correctly?
I used these:
=OFFSET(INDIRECT(C4),0,0,C
=OFFSET(INDIRECT(VLOOKUP(C
But none are helping…
How to do that?
EEQs22.xlsx
ASKER
The source for the data validation will be growing or changing so hose needs to be dynamic
ASKER
Thomas,
Thank you for your suggestion….In your file, when I click on select choices (C5), it’s not showing the options for the dropdown….
Thank you for your suggestion….In your file, when I click on select choices (C5), it’s not showing the options for the dropdown….
ASKER
ASKER
I tried to reassign the C5 data validation as indirect (C4) >> then the data validation says—this evaluates to an error, do you want to continue?
ASKER
The moment I changed the source range are changed from dynamic to static, the data validation works
then how can data validation be made from dynamic source??
then how can data validation be made from dynamic source??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello Royra,
Awesome…You rock. In my previous interactions as well, with you over EE, I have always seen that you have tried to solve the problem in the most quick and efficient way possible. Kudos to you.
Rayne
Awesome…You rock. In my previous interactions as well, with you over EE, I have always seen that you have tried to solve the problem in the most quick and efficient way possible. Kudos to you.
Rayne
=OFFSET(SourceMySource!$C$
(example for myRng1)
Thomas