vlookup - extracting cell content from external spread sheet

[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

 

[T. Valko]

Make sure calculation is set to automatic:

Tools>Options>Calculation tab>Automatic>OK

 

[Christian]

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!

Make sure calculation is set to automatic:

Tools>Options>Calculation tab>Automatic>OK


--
Biff
Microsoft Excel MVP

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

 

[T. Valko]

Send a SMALL sample file to:

xl can help at comcast period net

Remove "can" and change the obvious.

--
Biff
Microsoft Excel MVP

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!

Make sure calculation is set to automatic:

Tools>Options>Calculation tab>Automatic>OK


--
Biff
Microsoft Excel MVP

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