Check a value based on product code and date

Hello,

Been looking for a solution for sometime now but not found anything that meets my requirements and hope someone can help!

I receive a file containing invoice details (see tab 'invoices') and I want check the prices are correct against my price file.

My price file has 'standard' prices and another tab showing promotion prices.

What I am trying to do is to take the product code and date from the invoice and find a match from the price file.

Hope I've explained this well enough.

HDD_sheds

Hi Pepe Le Mokko
Thanks for your quick reply.
Sorry I have confused the issue with 'sku' which is a retail term for a product/item and stands for 'selling keeping unit'.
The empty column are blank as would any data wouldn't be applicable as product code not included in the 'invoice' sheet.

Hi, I was looking at helping out with this one too. Like Pepe, I got a bit confused.

In the notes included in your example file you have sentences like "First match row C with row H and then date in row B must be between date range in rows I:J" but you have no data in columns H, I or J so it's unclear what you're actually trying to achieve.

Perhaps you edited the file after writing the notes and didn't amend the notes, but if you have a look at the example file, it makes little sense.

If you can correct that I'm sure we'll be able to help further.

BSB.

Oh! I have really messed up here!
When I wrote the comments I had all the data on the one sheet and decided to tidy it up by separating the three sets of data onto different sheets but didn't change the comments!
Comments now updated and should now make some sense (hopefully). See new file Proposed Price File with invoice checking 1
Sorry for the confusion.