Hi everyone,
I'm aiming for a formula to split out the minimum option based off numerous conditions; although instead of returning the numerical value I want to know the corresponding value in a text based column.
I'm thinking a combination of index/match/min/arrayformula/xlookup is required.
I've created a table below to help articulate what I'm after. I have a data source table, and need the formula to be separate.
Date source:
Table with incomplete formula:
I hope this isn't sacrilege but I use Google Sheets as much as Excel so some formulas like aggregate won't work for me. Would really appreciate any help!
I'm aiming for a formula to split out the minimum option based off numerous conditions; although instead of returning the numerical value I want to know the corresponding value in a text based column.
I'm thinking a combination of index/match/min/arrayformula/xlookup is required.
I've created a table below to help articulate what I'm after. I have a data source table, and need the formula to be separate.
Date source:
| Product | Country | Supplier | Price |
| ABC | China | XMC Industries | $5 |
| ABC | China | Shanghai INT | $2 |
| ABC | Singapore | CAB INT | $15 |
| ABD | Singapore | LAB Tech | $4.5 |
| ABD | Singapore | CAB INT | $6 |
| ABD | China | XMC Industries | $15 |
Table with incomplete formula:
| Product | Singapore | China |
| ABC | CAB INT | FORMULA HERE TO FIND THE LOWEST PRICE SUPPLIER FOR ABC |
| ABD | LAB Tech | FORMULA HERE TO FIND THE LOWEST PRICE SUPPLIER FOR ABD |
I hope this isn't sacrilege but I use Google Sheets as much as Excel so some formulas like aggregate won't work for me. Would really appreciate any help!
