HLOOKUP Row_index_num help

Originally Posted by 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

try

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

but that will not work past row 31

hth
---