Hello everyone, hopefuly someone can help me, with a variation of a problem i was having before.
I've attached an example spreadsheet which i hope will help explain what i am trying to do, but to basically explain, i'm trying to create a formula to find the lowest cost price of a product from a list of multiple suppliers, while excluding suppliers from a specific location.
On the sheet titled Raw Data, i have an example list of pricing from each supplier by destiantion. on the sheet titled Final Cost, i want to be able to use a formula to find the lowest cost from the Raw data sheet, but exlcuding the pricing from suppliers in Shanghai.
Bookmarks