| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hlookup-row_index_num question
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup-row_index_num question
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup-row_index_num question
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup-row_index_num question
Buy a book on the fundamentals of Excel and read it.
"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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hlookup-row_index_num question
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLOOKUP question | Excel Worksheet Functions | |||
| VLOOKUP / HLOOKUP Question | Excel Discussion (Misc queries) | |||
| Can the Row_Index_Num in HLOOKUP adjust relatively? | Excel Worksheet Functions | |||
| VLOOKUP/HLOOKUP Question | Excel Discussion (Misc queries) | |||
| Changing the Row_index_num via HLOOKUP | Excel Worksheet Functions | |||
Linear Mode
