If your data is in Sheet1 and your data validations in Sheet2, then the formula would be more like:
=INDIRECT("'Sheet1'!"&B1)
If your data is in Sheet1 and your data validations in Sheet2, then the formula would be more like:
=INDIRECT("'Sheet1'!"&B1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks