Pulling OT hours

[aligahk06]

Dear All,
I want to pull data from timecard sheet to overtime sheet under following condition.
in overtime sheet if A2C2 match with timecard sheet A2B2 then return value of M2 in cell C2.
LIKEWISE A2D2 MATCH WITH A3B3 then return value in cell C3 FROM M3 and so on.

Any help,

Rgds,

aligahk06

 

[navic]

See if the file attachment is a solution for you
The ARRAY formula in cell 'C2' is below, copy across

=INDIRECT("TImeCard!$M"&MATCH($A2&"#"&C$1,TImeCard!$A$2:$A$1881&"#"&TImeCard!$B$2:$B$1881,0)+1)

 

[Luke M]

Formula in C2 of Overtime sheet
=SUMIFS(TimeCard!$M:$M,TimeCard!$A:$A,$A2,TimeCard!$B:$B,C$1)

 

[navic]

Bravo @Luke M, I didn't remember the SUMIFS function. It's a better way.

 

[Luke M]

@aligahk06

You posted this same question here: https://www.msofficeforums.com/excel/43076-pulling-data.html

This is called cross-posting, which while allowed, requires that you post links to your other questions so that answering members of the various communities can be aware of when an issue has been solved. Please take a moment to review forum guidelines.