Calculate cheapest price based on two criteria’s from a selection of cells in spreadsheet

Hi,

I'm not sure if someone can help but I think I am looking for a formula so I can calculate the cheapest price in a specific range of cells and highlight the supplier from the spreadsheet. The formula will need to look at two criterias in order to achieve this. I think this is quite complicated but I am not so good with formulas so perhaps it is not as bad as I think it is. As I don't know where to begin I have attached an example spreadsheet which will hopefully explain better what I am looking for. It maybe that a formula is not sufficient but I hope that someone can advise and help me find a solution.

Many thanks for your help
Kaz

Hi Haseeb,

Unfortunately the calculation is not finding the correct price and does not hightlight the supplier code. Would you mind taking another look incase I have done something wrong. I have attached the spreadsheet again with your formulas so you can see what I am getting - sorry.

Any help is greatly appreciated.
Kaz

Hi Haseeb,

Sorry, I realised my mistake, I was not entering with CTRL+SHIFT+ENTER as you clearly pointed out. This is fantastic, it is so good, thank you.

You are very kind helping me, I really appreciate it. I am just so impressed and amazed

Thank you ever so much
Kaz