Indirect & addree combination

  • Thread starter Thread starter Sekar
  • Start date Start date
S

Sekar

=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
 
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
 
Back
Top