Hello! Is there a way for me to use the sheet name within the formula on Data Validation function? I tried the INDIRECT function but it is not working. Hope you can help me! Thank you!
Hello! Is there a way for me to use the sheet name within the formula on Data Validation function? I tried the INDIRECT function but it is not working. Hope you can help me! Thank you!
Hello,
One way:
=OFFSET(INDIRECT("'"&C2&"'!B3"),,,100)
Assuming you have 100 rows of data, adjust the red highlighted if not.
It is better to create a dynamic named range then use that in the data validation source.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
It worked! Thank you!
Last edited by AliGW; 08-08-2020 at 03:07 AM. Reason: Please don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks