vlookup function addressing

[[email protected]]

Hi,

I would like to use this:
+vlookup(value, data range, col, false)

data range = start position:B20

the value of the start position is stored in cell D1, it is
"calculated" by some functions and put into cell D1

how do i used vlookup to use the start position in D1 automatically? i
do not want to type it manually

[Harlan Grove]

[email protected] wrote...
>I would like to use this:
>+vlookup(value, data range, col, false)
>
>data range = start position:B20
>
>the value of the start position is stored in cell D1, it is
>"calculated" by some functions and put into cell D1
>
>how do i used vlookup to use the start position in D1 automatically? i
>do not want to type it manually

You could use

INDIRECT(D1):B20

as data range, but you may be better off using

INDEX($A:$B,row expression,column expression)

where the row and column expressions would be similar to the formulas
you're using to produce your D1 value.

[[email protected]]

thanks Harlan!

i've been messing around for a few hours on this!