How do I use cell contents as an address in a formula

G

Guest

I want to create a formula like follows:
= 'sheet name'!B38 where 'sheet name' is the contents of another cell,
such as g2.

So, if g2 contained "Division 1" as its contents, the formula would return
the contents of the cell B38 on thesheet labeled "Division 1"
 

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

Build excel formula using field values as text in the formula 2
How to use a cell value as the ref argument in CELL"contents" form 3
in formulas how can I use contents of a cell? 3
using strings in vlookup function calls 5
Can I use a worksheet name in a formula? 4
Vlookup and return sheet name also 2
need a formula 7
Driving an address 5

Top