formula range
 

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)

formula range
 

Hi

Try
=VLOOKUP($B$1,INDIRECT("'"&F1&"'!:D1969"),3,FALSE)

Note the quotes
" ' "&F1& " ' !:D1969"

--
Regards

Roger Govier


"ADK" wrote in message
...
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)

formula range
 

I don/t think the ' and ! should be there.
This is a cell reference, not a sheet reference

Is there a benefit, I am not aware of?

"Roger Govier" wrote:

Hi

Try
=VLOOKUP($B$1,INDIRECT("'"&F1&"'!:D1969"),3,FALSE)

Note the quotes
" ' "&F1& " ' !:D1969"

--
Regards

Roger Govier


"ADK" wrote in message
...
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)

formula range
 

Hi,

Here is a slightly simplier formula:

=VLOOKUP($B$1,INDIRECT(F1&":D1969"),3,FALSE)

--
Cheers,
Shane Devenshire


"ADK" wrote:

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)

formula range
 

You are quite correct. My mistake.
So used to dealing with sheets, I type it automatically<g

--
Regards

Roger Govier


"bj" wrote in message
...
I don/t think the ' and ! should be there.
This is a cell reference, not a sheet reference

Is there a benefit, I am not aware of?

"Roger Govier" wrote:

Hi

Try
=VLOOKUP($B$1,INDIRECT("'"&F1&"'!:D1969"),3,FALSE)

Note the quotes
" ' "&F1& " ' !:D1969"

--
Regards

Roger Govier


"ADK" wrote in message
...
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)

formula range
 

Thanks...this one worked great!




"ShaneDevenshire" wrote in
message ...
Hi,

Here is a slightly simplier formula:

=VLOOKUP($B$1,INDIRECT(F1&":D1969"),3,FALSE)

--
Cheers,
Shane Devenshire


"ADK" wrote:

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)