Calculations between sheets in a workbook using logic

Closed
Aj - Mar 13, 2015 at 11:23 AM
Hello,
Can you tell me if you know how to create a formula for calculation between sheets in a workbook IF values in columns on those sheets are equal?
I have a workbook with multiple sheets. In "Unpaid - All Parcels" sheet I have years in Column A, and amounts in Column C. In "Interest" sheet I have years in Column A and percentage's in Column B.
I want a calculation to multiply Column C of "Unpaid - All Parcels" sheet with Column B of "Interest" sheet IF the value in Column A of "Unpaid - All Parcels" sheet match the value in Column A of "Interest" sheet.
Do you know if this is possible? And if so, what my formula would be?
Thank you in advance for any help:)