HLOOKUP Row_index_num help

[matt_the_brum]

Hi,

I'm using =HLOOKUP(RATES!$B$10,PriceList!$B$2:$H$32,4,FALSE) in cell B4.
I want to copy the formula down column B, but I want the Row_Index_Num to be equal to the row number, not fixed at 4. Is there an easier way of doing this other than changing the formula manually in every cell?

Thanks,

Matt

[Bryan Hessey]

Hi,

I'm using =HLOOKUP(RATES!$B$10,PriceList!$B$2:$H$32,4,FALSE) in cell B4.
I want to copy the formula down column B, but I want the Row_Index_Num to be equal to the row number, not fixed at 4. Is there an easier way of doing this other than changing the formula manually in every cell?

Thanks,

Matt

try

=HLOOKUP(RATES!$B$10,PriceList!$B$2:$H$32,row(),FALSE)

but that will not work past row 31

hth
---

[matt_the_brum]

Thanks. I just increased the rows in my table array to allow for row 31.

[Bryan Hessey]

Thanks. I just increased the rows in my table array to allow for row 31.

good to see, and thanks for the response
---