Forum Discussion
Indirect references
Hello! I wish to use the contents of a cell to form a part of the worksheet reference in a formula. For example: Cell A1 contains the string: PH21 Cell A2 contains the string: IFS Elsewher...
The Basic Formula is
=VLOOKUP(G5,INDIRECT(A1&A24&A4),2,FALSE)
A4 is the Range
however A1 needs to be [PH21.xlsx]
and a2 needs to be IFS!
or you can add these to the formula.
try to get the contents of the Indirect in a cell so you can debug it first.
=VLOOKUP(G5,INDIRECT(A1&A24&A4),2,FALSE)
A4 is the Range
however A1 needs to be [PH21.xlsx]
and a2 needs to be IFS!
or you can add these to the formula.
try to get the contents of the Indirect in a cell so you can debug it first.