C
Christian
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
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