| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Fixed reference but move on colums Ref#
I have a spread sheet with a vlookup that i want to return the value of each
colum as i move it across (left to right) by week. how do i get the colum Ref# to change as i move left to to right, rather than change 52 formulas. -- Thank you Neil |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup Fixed reference but move on colums Ref#
Instead of using numbers from 1-52, and assuming the cells are contiguous,
you could use ...COLUMN()-4... The -4 is actually dependent on which column you begin in, and if your first data from your vlookup is in column F (aka column 6), then you would subtract 4 (so this would be the 2nd column of your table). HTH. -- John C "Neil" wrote: I have a spread sheet with a vlookup that i want to return the value of each colum as i move it across (left to right) by week. how do i get the colum Ref# to change as i move left to to right, rather than change 52 formulas. -- Thank you Neil |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup Fixed reference but move on colums Ref#
John C
Perfect Thank you so much this saved me a bunch of time. -- Thank you Neil "John C" wrote: Instead of using numbers from 1-52, and assuming the cells are contiguous, you could use ...COLUMN()-4... The -4 is actually dependent on which column you begin in, and if your first data from your vlookup is in column F (aka column 6), then you would subtract 4 (so this would be the 2nd column of your table). HTH. -- John C "Neil" wrote: I have a spread sheet with a vlookup that i want to return the value of each colum as i move it across (left to right) by week. how do i get the colum Ref# to change as i move left to to right, rather than change 52 formulas. -- Thank you Neil |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup Fixed reference but move on colums Ref#
Thanks for the feedback, and don't forget to check the YES box below. :)
-- John C "Neil" wrote: John C Perfect Thank you so much this saved me a bunch of time. -- Thank you Neil "John C" wrote: Instead of using numbers from 1-52, and assuming the cells are contiguous, you could use ...COLUMN()-4... The -4 is actually dependent on which column you begin in, and if your first data from your vlookup is in column F (aka column 6), then you would subtract 4 (so this would be the 2nd column of your table). HTH. -- John C "Neil" wrote: I have a spread sheet with a vlookup that i want to return the value of each colum as i move it across (left to right) by week. how do i get the colum Ref# to change as i move left to to right, rather than change 52 formulas. -- Thank you Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to leave column 1 and move all other colums up or down rows. | Excel Discussion (Misc queries) | |||
| error message fixed objects may move | Excel Discussion (Misc queries) | |||
| vlookup colums with reference to a formula from another sheet | Excel Worksheet Functions | |||
| Warning - "Fixed objects will move" | Excel Worksheet Functions | |||
| why can't you move colums in Excel like in Outlook? | Excel Worksheet Functions | |||
Linear Mode
