vlookup function addressing

[jacky.newsgroup]

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]

(e-mail address removed) 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.

 

[jacky.newsgroup]

thanks Harlan!

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