Precede the cell address with INDIRECT, such as INDIRECT(A1) will result in
the formula evaluating to say G15, if A1 contains text "G15"

"TimRTi" wrote:

I want to enter cell addresses and range addresses in formulas (functions)
such as vlookup using row and column numbers that are calculated elsewhere on
the spreadsheet. How do I write the range formula in a manner that takes its
cell address parameters from those other cells?