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