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)
|