| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP
Have this function
Look up value : A3 Table Array: '01'!Q:S Column Index Number:2 Range Look Up: False Want to copy formula into other column Not change Lookupvalue:A3 Change Table Array:02 and keeping adding for example column D=01. E=02,F=03 not change in table array Q:S How can I do this? -- Thanks Lynn |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
=VLOOKUP($A$3,OFFSET(INDIRECT(ADDRESS(1,17,1,1,TEX T(COLUMN(D3)-3,"00"))),0,0,100,2),2,FALSE)
^ This work for 100 rows, adjust it to expected max number of rows (or max row No, 65536 in Excel2003)! Regards, Stefi €˛Lynn€¯ ezt Ć*rta: Have this function Look up value : A3 Table Array: '01'!Q:S Column Index Number:2 Range Look Up: False Want to copy formula into other column Not change Lookupvalue:A3 Change Table Array:02 and keeping adding for example column D=01. E=02,F=03 not change in table array Q:S How can I do this? -- Thanks Lynn |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
Try
=VLOOKUP($A3,$Q:$S,COLUMN(A2),0) and copy to the column to the right..Since the array has got only 3 columns you have only Column Index Number:2 and 3 If this post helps click Yes --------------- Jacob Skaria "Lynn" wrote: Have this function Look up value : A3 Table Array: '01'!Q:S Column Index Number:2 Range Look Up: False Want to copy formula into other column Not change Lookupvalue:A3 Change Table Array:02 and keeping adding for example column D=01. E=02,F=03 not change in table array Q:S How can I do this? -- Thanks Lynn |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLOOKUP
To start from column index number 2 use
=VLOOKUP($A3,$Q:$S,COLUMN(B1),0) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try =VLOOKUP($A3,$Q:$S,COLUMN(A2),0) and copy to the column to the right..Since the array has got only 3 columns you have only Column Index Number:2 and 3 If this post helps click Yes --------------- Jacob Skaria "Lynn" wrote: Have this function Look up value : A3 Table Array: '01'!Q:S Column Index Number:2 Range Look Up: False Want to copy formula into other column Not change Lookupvalue:A3 Change Table Array:02 and keeping adding for example column D=01. E=02,F=03 not change in table array Q:S How can I do this? -- Thanks Lynn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
