Reference cell contents

[vzq032372]

I have an HLOOKUP formula in a cell, there is no problem returning the correct value

 HLOOKUP(C34,'Lines P4'!C35:C36,2,0)

I created another formula to get the cell contents which contains the sheet name, again no issue here

=CELL("contents",L35) & "!"

When I tried to consolidate the formulas I got an error. How do I merge these two formulas so that the sheetname lookup references the sheetname in L35, L36 etc as I go down the list?

 

[vzq032372]

I have an HLOOKUP formula in a cell, there is no problem returning the correct value

 HLOOKUP(C34,'Lines P4'!C35:C36,2,0)

I created another formula to get the cell contents which contains the sheet name, again no issue here

=CELL("contents",L35) & "!"

When I tried to consolidate the formulas I got an error. How do I merge these two formulas so that the sheetname lookup references the sheetname in L35, L36 etc as I go down the list?

The following worked:

=INDIRECT("'" & L35 "'!C36")