Thanks again - I think the data source is from a pivot table. Could you tell me how to overcome the following please? Ive attached an updated example whereby the delivery numbers all be it the same as its preceeding delivery number (in some cases) isn't in the cell and therefor throws the formula to lookup the value.
It wont always be the case there are multiple product types for a delivery number as per "TestCompany2" in the attached which only has one delivery number for one product.
|