ExcelBanter - vlookup function addressing

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup function addressing (https://www.excelbanter.com/excel-worksheet-functions/84145-vlookup-function-addressing.html)

[email protected]

vlookup function addressing

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

vlookup function addressing

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]

vlookup function addressing

thanks Harlan! :)

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

All times are GMT +1. The time now is 02:14 AM.