LinkBack URL
About LinkBacks
Could someone help me understand what the following formual is referencing?
=INDIRECT("'"&$A17&"'"&"!$Bs$86")
Could someone help me understand what the following formual is referencing?
=INDIRECT("'"&$A17&"'"&"!$Bs$86")
cell BS86 on a sheet whos name is stored in A17
A tab named whatever is in A17 and Cell BS86.
INDIRECT translates a string into references. =A1, =INDIRECT("A"&0+1), =INDIRECT(CHAR(ROW(A1)+64)&100-99) all reference A1. It's useful for creating many formulas without editing individual parameters by hand.
Last edited by daffodil11; 09-17-2013 at 12:02 PM.
Thank you for the fast response!!
and it's also unnecessarily long. this is the same:
=INDIRECT("'"&$A17&"'!$Bs$86")
When I say semicolon, u say comma!
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks