Hlookup-row_index_num question

[Eden397]

Hi,
I am wondering how I get the row number to sequentially increase as I copy
my HLOOKUP formula down a column. My Lookup Value and Table Array would be
the same but I want my row number to increase as I paste down the column. Is
there an easy way to do this? Thanks, Eden 397

 

[RagDyer]

Try something like this, which starts at Row2:

=HLOOKUP($A$20,$A$1:$K$5,ROWS($1:2),0)

 

[Eden397]

Thank you, Thank you, Thank you!

Try something like this, which starts at Row2:

=HLOOKUP($A$20,$A$1:$K$5,ROWS($1:2),0)

 

[Tyro]

Buy a book on the fundamentals of Excel and read it.

 

[RagDyeR]

Thank you for the feed-back.