Thread: Ref. a cell in a formula

Hello-

I am trying to reference a cell's contents in a formula. The cell is located in the same sheet but references a cell from another sheet.

Current formula: =LOOKUP(FHC!$A$2,$F$2:$F$13,$H$2:$H$13)

I would like to replace the "FHC! with the cell's contents found in F15 of the current sheet where the formula is found, sheet "admin".

Thanks for the help in advance.

-EW

Originally Posted by zbor

You mean like:

=LOOKUP(F15,$F$2:$F$13,$H$2:$H$13)

No dice, that just gives the cell as a reference but doesn't use the contents which is the sheet's name which the rest of the formula refers to.

Originally Posted by JBeaucaire

The INDIRECT() function should serve.

=LOOKUP(INDIRECT("'" & Admin!$F$15 & "'!$A$2"),$F$2:$F$13,$H$2:$H$13)

=LOOKUP(INDIRECT("'" & $F$15 & "'!$A$2"),$F$2:$F$13,$H$2:$H$13)

This gives the result in "TRUE" but should give a different result.

Originally Posted by wagnered

This gives the result in "TRUE" but should give a different result.

OK, so I take it all back...great formula! Thank you!