Thank you for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Eden397" wrote in message
...
Thank you, Thank you, Thank you!

"RagDyer" wrote:

Try something like this, which starts at Row2:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Eden397" wrote in message
...
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