sheet result of validation in a formula

  • Thread starter Thread starter rajasi
  • Start date Start date
R

rajasi

Hi all,

i've a validation list with the name of all the sheets in my workfile,
i need to insert the sheet choosen from list in a formula to take dat
from.. how i can do??

if the validation list is in cell A17 and i try to write down a formul
like:

=A17!$A$1

i got an REF error.

that's all, i hope to have explained the problem as well.
thanks for help
 
Think you need to use INDIRECT()

Instead of > =A17!$A$1

try: =INDIRECT("'"&A17&"'!$A$1")
 
Back
Top