Sheet in cell Reference

  • Thread starter Thread starter lshavit
  • Start date Start date
L

lshavit

hi all

i have in cell "a10" number 112244 which is one of the sheets name
i want to use cell referrence "a10" in formula , in order to get
value
from sheet 112244. ie : ='112244'!g4
i try a lot of variations without any success

thanks for any suggestio
 
=INDIRECT("'"&A1&"'!G4")
hi all

i have in cell "a10" number 112244 which is one of the sheets name
i want to use cell referrence "a10" in formula , in order to get
value
from sheet 112244. ie : ='112244'!g4
i try a lot of variations without any success

thanks for any suggestio
Click to expand...
 
You must log in or register to reply here.

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

Counting dates with conditions 2
I think an easy Conditional Formatting ? 4
VALUE err calculating indirect number 5
Sum column of cells that already contain a formula 2
Formula to find the last number of a column (lower cell) 1
Formula autofill to cells below – formula arguments are cell areas in different columns 1
How do I copy formulas down a sheet using increments? 1
wildcard in countif formula that uses cell references 3

Back
Top