Vlookup and sum

[Pammy]

I have a worksheet that in column A lists employee #'s, in column B, # of
hours worked. In Column M, I want to create a formula that will lookup an
employee # in Column A, get the hours worked in column B, then go to another
worksheet, look in column c find that empl # and get the hours worked in
column d, then give a total of hours worked in column M on my main
worksheeet. Is this possible?

 

[Luke M]

Assuming Employee number is listed in a cell, say Z2, why not use something
like this:

=SUMIF(A:A,Z2,B:B)+SUMIF('Sheet2'!C:C,Z2,D)

 

[Bernie Deitrick]

Pammy,

In M, use a formula like

=VLOOKUP(Emp#,A:B,2,False)+VLOOKUP(Emp#,Sheet2!C,2,False)

Where Emp# is a cell with the value of interest.

HTH,
Bernie
MS Excel MVP