Formula

P

Pete Bodie

I would like to create a formula in a cell that uses the value from another
cell to compleat the formula.
Formula in A1 =daily[value from A2)!c5 Where A2 is 01
Finished formula would be =daily01!c5
Is this possible
 
R

RagDyeR

Try this:

=INDIRECT("daily"&A2&"!C5")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to create a formula in a cell that uses the value from another
cell to compleat the formula.
Formula in A1 =daily[value from A2)!c5 Where A2 is 01
Finished formula would be =daily01!c5
Is this possible
 
R

Ragdyer

You're welcome.

Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Pete Bodie said:
It works great. What a time saver this going to be.
Thank You

RagDyeR said:
Try this:

=INDIRECT("daily"&A2&"!C5")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to create a formula in a cell that uses the value from another
cell to compleat the formula.
Formula in A1 =daily[value from A2)!c5 Where A2 is 01
Finished formula would be =daily01!c5
Is this possible
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
Excel - Wich Function should I use? 1
Newbie Help - IF Yes No Function 0
countifs Function not giving desired result with date criteria 2
Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
MS Project. Real progress of the project, % complete 1
Vlookup and return sheet name also 2

Top