| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlook Question
Can you drag a vlookup formula and have the col_index_num follow?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlook Question
Denise,
One way =VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE) Start in column 2 of the table and dragged right becomes column 3 etc or =VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE) same effect dragged down Mike "Denise" wrote: Can you drag a vlookup formula and have the col_index_num follow? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlook Question
Thank you so much, that worked like a charm...
"Mike H" wrote: Denise, One way =VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE) Start in column 2 of the table and dragged right becomes column 3 etc or =VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE) same effect dragged down Mike "Denise" wrote: Can you drag a vlookup formula and have the col_index_num follow? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlook Question
your welcome
"Denise" wrote: Thank you so much, that worked like a charm... "Mike H" wrote: Denise, One way =VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE) Start in column 2 of the table and dragged right becomes column 3 etc or =VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE) same effect dragged down Mike "Denise" wrote: Can you drag a vlookup formula and have the col_index_num follow? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLook UP formula question | Excel Worksheet Functions | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
| vlook up | Excel Discussion (Misc queries) | |||
| Vlook up question - I think ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
