Looking up min value in a table with the unqiue identifier repeated multiple times

[joshuax]

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

[BadlySpelledBuoy]

Assuming your sample data is in A1:C9, enter the SKU you wish to look up the minimum price location for in F1 and the below formula where you want the result.

Please Login or Register  to view this content.

This is an array formula and therefore needs to be confirmed with Ctrl+Shift+Enter rather than just Enter.

BSB