Understanding text references as cell locations for use in defining ranges

I have set up formulas that dynamically generate the location of the first and last locations of a range on a separate tab, however I don't know how to have a VLOOKUP understand the text as a cell reference.

For instance, on Sheet1, I have a formula that looks at Sheet2 and shows that A2 is the beginning of a range, thus populating the text "A2" on Sheet1 in cell G24. Sheet1 cell G25 has a formula that calculates the last number in the Sheet2 range (say, K10), and populates the text "K10" in G24 on Sheet1.

If there is a VLOOKUP formula on Sheet1, how can I have it use the range Sheet2!A2:K10, referring to the text populated in G24 and G25?

Many thanks in advance for any help you can provide!

Hi and welcome to the board

try INDIRECT for referencing in the following way INDIRECT("Sheet2!"&G24&":"&G25)

OMG THANK YOU! This little formula will save me a ton of time on my project. I really, truly appreciate your help.

Originally Posted by arthurbr

Hi and welcome to the board

try INDIRECT for referencing in the following way INDIRECT("Sheet2!"&G24&":"&G25)