Posted 31 March 2022, 9:48 pm EST
we have a range in our worksheet that contains a validation of type list. Let’s say our validation formula is:
"=IF( Test="abc" , Worksheet1!$A$1:$A$3 , Worksheet1!$B$1:$B$5 )"
All we want to do is to read the list of values from this formula, which would be either the values A1:A3 or B1:B5 from Worksheet1. Could you please tell us how we can achieve this?
Thanks in advance, Maya