Need Help Creating a Formula

[Joefried]

If the following options are met:
1) 'sheet2'A:A matches 'sheet1'A21
2) 'sheet2'D:D matches 'sheet1 F20

i will need the results of all answers in a total

Please help

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=569638

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).