Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can a formula be created using values from a field?

Status
Not open for further replies.

alwayslrN

IS-IT--Management
Jun 20, 2006
159
US
I am using Excel 2002 SP3. I was wondering if the following could be done in Excel.

A5 = ABCD
a tab is named ABCD

there is a formula that looks like =ABCD!$E$17

I want to be able to build the forumula using the value from A5. Is that possible?
 
What about the INDIRECT function ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Hi PH

I forgot to mention that A5 is in a different worksheet than worksheet ABCD
 
As you asked in the VBA forum, a VBA suggestion:
SomeRange.Formula = "=" & SomeSheet.Range("A5") & "!$E$17"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Hi alwayslrN:

I had a little play with it and using the setup proposed by PHV, the following worked for me ...
Code:
someRange.formula="=indirect(A5&""!E17"")"

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top