I have an HLOOKUP formula in a cell, there is no problem returning the correct value
I created another formula to get the cell contents which contains the sheet name, again no issue here
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?
Excel Formula:
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
Excel Formula:
=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?