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
Bookmarks