Indirect & addree combination
 

=INDIRECT("'" & A2 & "'!" & B2)
I taken this formula which is not working as in demo itself.

Any body have the usage of like combinations of Indirect & address function
in formulas

Indirect & addree combination
 

Try the below formula in sheet1 cell C2...This will reference the sheet name
mentioned in cell A2 (in this case it is the sheet1 itself) and the cell
mentioned in B2 (in this case it is A2)....So it will reference back to
Sheet1 cell A2..Try changing the entries in A2 and B2

ColA ColB ColC

Sheet1 A2 =INDIRECT("'" & A2 & "'!" & B2)

If this post helps click Yes
---------------
Jacob Skaria


"Sekar" wrote:

=INDIRECT("'" & A2 & "'!" & B2)
I taken this formula which is not working as in demo itself.

Any body have the usage of like combinations of Indirect & address function
in formulas

Indirect & addree combination
 

Hi jacob

Yes it is working , thanx for the same.

Rgds

Dharmasekar.
"Jacob Skaria" wrote:

Try the below formula in sheet1 cell C2...This will reference the sheet name
mentioned in cell A2 (in this case it is the sheet1 itself) and the cell
mentioned in B2 (in this case it is A2)....So it will reference back to
Sheet1 cell A2..Try changing the entries in A2 and B2

ColA ColB ColC

Sheet1 A2 =INDIRECT("'" & A2 & "'!" & B2)

If this post helps click Yes
---------------
Jacob Skaria


"Sekar" wrote:

=INDIRECT("'" & A2 & "'!" & B2)
I taken this formula which is not working as in demo itself.

Any body have the usage of like combinations of Indirect & address function
in formulas