Unable to countif sumif match, link sheets and auto populate between worksheets

Hi

Am not that well trained know a couple of bits but have the following proble.

I wish to match 2 different criteria from two diff columns on 2 worksheets and return a third cell contents if they match.

Please see the attached work book.

I wish to match the 'week numbers' and the 'ELR' on sheet 1 and sheet 2 and returnd the total work completed from sheet 1 S column to sheet 2 planned column (for each ELR)

Ive tried if and and a few others but cant manage to get it right - also trying to avoid $'s as i wish to drag the formula.

Any help would be greatly appreciated.


Kind regards

Thank you very much i have been away on leave but will try this out ASAP