software

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
quot;calculatedquot; 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

wrote...
gt;I would like to use this:
gt; vlookup(value, data range, col, false)
gt;
gt;data range = start position:B20
gt;
gt;the value of the start position is stored in cell D1, it is
gt;quot;calculatedquot; by some functions and put into cell D1
gt;
gt;how do i used vlookup to use the start position in D1 automatically? i
gt;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.thanks Harlan!

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