Using sheetname variable in a formula

M

mms

Yes that WORKS!!

Thank you!

One minor glitch however.

My *desired* sheet name is *A-325* and the like (A-490, etc)

Your code does not work for that name, however if I change it to *A325
it works.

Any ideas why this is happening
 
F

Frank Kabel

Hi
should work. Have you included the apostrophes ' in the formula. Post
the exact formula you have used
 
P

pikapika13

In that case you have the enter values in A1 like this:

="'A-325'"

Its hard to see but it is: <equal sign><double quotes><singl
quote><sheet_name><single quote><double quote>

Please let me know if this work
 
P

pikapika13

This also works ( I think this is better):
=INDIRECT(""&"'"&$A$1&"'"&"!$A$3")
it is : double quote, double quote, &, double quote, single quote
double quote,&,sheet name, &, dq,sq,dq, etc.
Let me know if this is too cryptic..
 
Top