Forum Discussion
Solved
Comparing a price list to an invoice
Hi, I have a price list & an invoice both of which are very long, the supplier is charging more for some items on their invoice than agreed in the price list but not all items, I would like a formul...
In J4:
=H4-VLOOKUP(E4,$A$4:$C$8,3,FALSE)if you want to compare the prices, or
=G4*(H4-VLOOKUP(E4,$A$4:$C$8,3,FALSE))if you want to calculate the overcharge on the total.
Adjust the range, then fill down.
In J4:
=H4-VLOOKUP(E4,$A$4:$C$8,3,FALSE)if you want to compare the prices, or
=G4*(H4-VLOOKUP(E4,$A$4:$C$8,3,FALSE))if you want to calculate the overcharge on the total.
Adjust the range, then fill down.
HansVogelaar Thanks for your help Hans, you have answered my question perfectly.