Hello,
I'm using Excel 2010...
I have a large worksheet (about 12k rows) with three columns of products/prices. I need some formula which will find the price of a barcode at a given date. e.g. what is the price of 10009 on 3/1/15? (It would be at the last provided price, i.e. £1.10). Any...