Reference cell value in a formula

[kollizion]

Hi, im trying to reference the value of a cell to be placed in a VLOOKUP formula.

Value of cell A1 = A100 (this is the start of the array)
Value of cell B1 = B125 (this is the end of the array)
Value of cell A2 = A200
Value of cell B2 = B225
etc., etc.

But i want the values of those cells to be placed in a vlookup formula like so..

=VLOOKUP(B14,Sheet1!$(Value of cell A1):$(Value of cell B2),3,FALSE)

does that make sense?

[Domenic]

Try...

=VLOOKUP(B14,INDIRECT("'Sheet1'!"&A1&":"&B2),2,FALSE)

Of course, a column index of '3' would be invalid since in this case the table array is made up of only two columns.

Hope this helps!

[kollizion]

worked perfect! thanks!