Vlookup question involving two worksheets and then summing data

[lilsnoop]

Hello, This has been an ongoing project which I now have found a problem with. I'm looking for a formula that would look up the individual employee (i.e. Name1 for example) in the January sheet and then look for and sum any amounts that have a number and a symbol as reflected in A2 through A10 (8V, 4V▲,etc), which would then be calculated with a similar formula for the February sheet, specifically the time period between 1/26/14 and 02/08/14 as indicated above. As employees can switch shifts, the formula would have to locate now in February where employee (Name1) is and find that row for the same symbol/number calculations for this same time period in that given month. Currently I'm using an array formula which can be seen in the attached file in cell I4. The problem is that the formula assumes that Name1 is always in the same spot in all monthly sheets which isn't the case month to month and thus causes me more gray hair. The formula looks like this without the vlookup portion:

Please Login or Register  to view this content.

I also need to do a similar vlookup or match, etc with this formula too:

Please Login or Register  to view this content.

Any assistance would be greatly appreciated!!

[RobertMika]

Would there be always only 2 sheets involved?

[kvsrinivasamurthy]

In I4 Use this ARRAY formula and drag down

Please Login or Register  to view this content.

In O4 Use this formula and drag down

Please Login or Register  to view this content.

[lilsnoop]

I appreciate your efforts looking at this issue for me.

RobertMika-My workbook will have multiple sheets (January through December plus some additional sheets). The pay period ranges will only involve 2 worksheets at most though when typically near the end of one month and carrying over into the next.

kvsrinivasamurthy-I tried both formulas and the top one didn't produce the results I needed and the bottom one gave me a #REF!.

[RobertMika]

kvsrinivasamurthy worked on his copy of your workbook
He has "Payroll (2)" sheet whereas your is just "Payroll"
Removed the (2) from the formula

[lilsnoop]

Ah.. good catch Robert will test it out!

[lilsnoop]

Thanks so much kvsrinivasamurthy!!

[kvsrinivasamurthy]

@RobertMika
Thanks for the suggestion.
@lilsnoop
Thanks for the compliments.