Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup - extracting cell content from external spread sheet
I have 2 xls sheets.
sheet one: A B C D E F G work code sheet 2 : A B C .... H work code filepath of folders (i.e c:\docs\work\work code\12344) the work code is the unique identifier I would like to use to extract the filepath location from sheet 2 (column H ) into sheet 1 (lets say column G ). I have no problems extracting 1 filepath value form sheet 2 into sheet 1, however, as soon as I want to copy the function to conduct the same process for other work codes it delivers the same value into the result cell. To make things more interesting: The sheet 1 is the master document with about 900 work codes and the sheet 2 has just parts of them.(i will be recieving multiple sheets from each division). Ideally I would like to set up a vlookup that i can adapt and run with the master work sheet and the incoming Sheet2 - types. The vlookup function that works for 1 value looks like this : VLOOKUP(A1,'[masterjobs.xls]A7 - Jobs'!$A$4:$M$10,12) I hope I could exlpain clearly. I really would like to understand my mistake/problem. Kind Regards Christian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup - extracting cell content from external spread sheet
Make sure calculation is set to automatic:
ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "Christian" <Christian @discussions.microsoft.com wrote in message ... I have 2 xls sheets. sheet one: A B C D E F G work code sheet 2 : A B C .... H work code filepath of folders (i.e c:\docs\work\work code\12344) the work code is the unique identifier I would like to use to extract the filepath location from sheet 2 (column H ) into sheet 1 (lets say column G ). I have no problems extracting 1 filepath value form sheet 2 into sheet 1, however, as soon as I want to copy the function to conduct the same process for other work codes it delivers the same value into the result cell. To make things more interesting: The sheet 1 is the master document with about 900 work codes and the sheet 2 has just parts of them.(i will be recieving multiple sheets from each division). Ideally I would like to set up a vlookup that i can adapt and run with the master work sheet and the incoming Sheet2 - types. The vlookup function that works for 1 value looks like this : VLOOKUP(A1,'[masterjobs.xls]A7 - Jobs'!$A$4:$M$10,12) I hope I could exlpain clearly. I really would like to understand my mistake/problem. Kind Regards Christian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup - extracting cell content from external spread sheet
it is. Still same result.
would it help if i could email you abbreviated files to see (i can do screenshoots in word format for example)? it is a bit hard just to explain in plain text. Appreciate your efforts! "T. Valko" wrote: Make sure calculation is set to automatic: ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "Christian" <Christian @discussions.microsoft.com wrote in message ... I have 2 xls sheets. sheet one: A B C D E F G work code sheet 2 : A B C .... H work code filepath of folders (i.e c:\docs\work\work code\12344) the work code is the unique identifier I would like to use to extract the filepath location from sheet 2 (column H ) into sheet 1 (lets say column G ). I have no problems extracting 1 filepath value form sheet 2 into sheet 1, however, as soon as I want to copy the function to conduct the same process for other work codes it delivers the same value into the result cell. To make things more interesting: The sheet 1 is the master document with about 900 work codes and the sheet 2 has just parts of them.(i will be recieving multiple sheets from each division). Ideally I would like to set up a vlookup that i can adapt and run with the master work sheet and the incoming Sheet2 - types. The vlookup function that works for 1 value looks like this : VLOOKUP(A1,'[masterjobs.xls]A7 - Jobs'!$A$4:$M$10,12) I hope I could exlpain clearly. I really would like to understand my mistake/problem. Kind Regards Christian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup - extracting cell content from external spread sheet
Send a SMALL sample file to:
xl can help at comcast period net Remove "can" and change the obvious. -- Biff Microsoft Excel MVP "Christian" wrote in message ... it is. Still same result. would it help if i could email you abbreviated files to see (i can do screenshoots in word format for example)? it is a bit hard just to explain in plain text. Appreciate your efforts! "T. Valko" wrote: Make sure calculation is set to automatic: ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "Christian" <Christian @discussions.microsoft.com wrote in message ... I have 2 xls sheets. sheet one: A B C D E F G work code sheet 2 : A B C .... H work code filepath of folders (i.e c:\docs\work\work code\12344) the work code is the unique identifier I would like to use to extract the filepath location from sheet 2 (column H ) into sheet 1 (lets say column G ). I have no problems extracting 1 filepath value form sheet 2 into sheet 1, however, as soon as I want to copy the function to conduct the same process for other work codes it delivers the same value into the result cell. To make things more interesting: The sheet 1 is the master document with about 900 work codes and the sheet 2 has just parts of them.(i will be recieving multiple sheets from each division). Ideally I would like to set up a vlookup that i can adapt and run with the master work sheet and the incoming Sheet2 - types. The vlookup function that works for 1 value looks like this : VLOOKUP(A1,'[masterjobs.xls]A7 - Jobs'!$A$4:$M$10,12) I hope I could exlpain clearly. I really would like to understand my mistake/problem. Kind Regards Christian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display external data inside of an Excel 2007 Spread sheet | Excel Worksheet Functions | |||
sheet tab = to cell content | Excel Discussion (Misc queries) | |||
how do i enter a bull call spread into the options spread sheet ? | Excel Worksheet Functions | |||
how do i compare 2 spread sheets if the content of a cell is avai. | Excel Worksheet Functions | |||
vlookup to extract part cell content | Excel Discussion (Misc queries) |