Hi guys,

I have a question here. My company is purchasing the same stuff from 2 or more locations.

This means the same SKU will come from a couple of locations with different prices.

My task is to identify the location for which the lowest cost is coming from.

Normally you can use vlookup. In this case you can't because the unique identifier (SKU) is repeated a few times in the table.

Appreciate any help


Location 1 23.16 AUB0001159
Location 1 22.42 AUB0001159
Location 2 49.57 AUB0000043
Location 2 45.44 AUB0000043
Location 2 48.19 AUB0000043
Location 1 3.78 AUB0001057
Location 2 12.4 AUB0001096
Location 2 15.30 AUB0000891-14
Location 2 15.18 AUB0000891-14