| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup and autofill
Can i use autofill to increase the column count it looks in?
On row 1 for example I have =vlookup($b3,sheet1!$a:$cg,5,0) and i then want to increment it by 3 in the next column i.e. =vlookup($b3,sheet1!$a:$cg,8,0) and then =vlookup($b3,sheet1!$a:$cg,11,0) and so on. Thanks in your advance for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No autofill VLookup function | Excel Worksheet Functions | |||
| VLOOKUP Changing reference cells in autofill | Excel Worksheet Functions | |||
| Using VLOOKUP in VBA code | Excel Worksheet Functions | |||
| Autofill Formula | Excel Discussion (Misc queries) | |||
| Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
Threaded Mode
