I have to sets of data to compare invoice number is column A and amount in B verse C & D . Answer in E
i have much more data then this going down the whole sheet. What i am trying to do in column E and need help with is a formula that if column A invoice number and column B on same line match column C and D to return zero. If it cant locate the invoice number in column A & C then return NA. which means its not found. As you can see if it finds A & B with C & D and the amount if off it return the difference. Can this be done in a formula or macro. Any help would be apricated.
Invoice number is column A to E
Excel 2016 (Windows) 32 bit
i have much more data then this going down the whole sheet. What i am trying to do in column E and need help with is a formula that if column A invoice number and column B on same line match column C and D to return zero. If it cant locate the invoice number in column A & C then return NA. which means its not found. As you can see if it finds A & B with C & D and the amount if off it return the difference. Can this be done in a formula or macro. Any help would be apricated.
Invoice number is column A to E
Excel 2016 (Windows) 32 bit
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Invoice Number | Amount | Invoice Number | Amount | Diffrence |
2 | 25613 | $ 600.00 | 25613 | $ 750.00 | $ (150.00) |
3 | 15623 | $ 1,200.00 | 45652 | $ 500.00 | NA |
4 | 45698 | $ 1,500.00 | 45698 | $ 1,500.00 | $ - |
5 | 46523 | $ 1,600.00 | 46523 | $ 1,650.00 | $ (50.00) |
Sheet: Payroll Week Ending |