Here is my example!
Schedule Sheet
A B C D E F
Ref Cost Jan Feb Mar Apr
1 Sal 5 6 5
2 NI 1 1 1
March Sheet
A B C
Ref Cost Apr
1 Sal 1
1 Sal 2
1 Sal 2
I would like to use a vlookup so that it finds the April costs and sums them so i can return the full cost into the Schedule sheet! Ive looked at the boards and have tried a number of things, could someone please provide a formula specifically for this example?
Schedule Sheet
A B C D E F
Ref Cost Jan Feb Mar Apr
1 Sal 5 6 5
2 NI 1 1 1
March Sheet
A B C
Ref Cost Apr
1 Sal 1
1 Sal 2
1 Sal 2
I would like to use a vlookup so that it finds the April costs and sums them so i can return the full cost into the Schedule sheet! Ive looked at the boards and have tried a number of things, could someone please provide a formula specifically for this example?
