S
steph
Hello,
I'm trying to make a formula which looks for a certain value in another
workbook. My worksheet in which the formula has to be entered contains the
payroll number and on the basis of this payrollnumber and the code
(101,140,...) a value of a certain month needs to be returned from the second
workbook.
This second workbook has a layout which looks like this :
A B C D E F G
H
name first name payrollnr jan feb mrch apr may
smith john 001/02
101 10 10 20 30 25
135 16 25 45 10 36
140 ...
145
johnson kelly 001/02
101 12 32 25 21 15
135 ...
140
145
Can anyone help me as i'm struggling with index, match and vlookup to make
it somehow right ?
thanks
I'm trying to make a formula which looks for a certain value in another
workbook. My worksheet in which the formula has to be entered contains the
payroll number and on the basis of this payrollnumber and the code
(101,140,...) a value of a certain month needs to be returned from the second
workbook.
This second workbook has a layout which looks like this :
A B C D E F G
H
name first name payrollnr jan feb mrch apr may
smith john 001/02
101 10 10 20 30 25
135 16 25 45 10 36
140 ...
145
johnson kelly 001/02
101 12 32 25 21 15
135 ...
140
145
Can anyone help me as i'm struggling with index, match and vlookup to make
it somehow right ?
thanks