I've been using a spreadsheet for the past two years with several array formula's in it and it's been working perfectly fine.
I made some changes to the layout, basically only changing the order items were listed in the column and the order items were listed in the range that the formula referenced and now I cannot get the formula to work.
I have attached a simplified version of the spreadsheet and the formula is found in column D in the sheet titled XMN to UK Lowest Cost FCL.
The ranges are in the sheet titled Pricing (FOB & Landed)
Please can someone help, it's been driving me round the twist for quite some time.
Bookmarks