HLOOKUP in Excel- increment row_index_num
Posted on 2011-03-17
I have a HLOOKUP formula:
=HLOOKUP(QR5,$B$3:$QO$5000,2) where 2 is the row_index_num
I need to be able to increment that row index num by 1 each when the formula is copied to the next row. I tried using a simple counter and referencing that row_index_num to the cell containing the counter, but returned an error message (#VALUE)
Any help appreciated...