is there any way to make A2 in the formula a function of a cell value?

=VLOOKUP($B$1,A2:D1969,3,FALSE)


Example: if F1 = the value of: "A50"

So the formula in A1 would be:

=VLOOKUP($B$1,A50:D1969,3,FALSE)