Multiple conditions

[madocar]

Hi,

is it possible in excel to make multiple conditions by choosing the right value. I would like to choose one value from tab "B" to tab "A" according to condition from tab "B":

- the highest price, in case there are two highest prices, choose that with less value of "Best before date"

- in case of having the same value of Best before date, choose the one with higher "Parameter 1"

- in case of having the same value of "Parameter 1", choose the one with higher "Parameter 2"

So in my example, the final result should be in tab "A", product from seller "Gary"

Is it even possible to do that? More in attached file

Thanks for any help

 

[NARAYANK991]

Hi ,

I have used a lot of helper cells and columns ; see if the result is correct.

Narayan

 

[madocar]

Narayan you are perfect!
Thanks for help

 

[Haz]

I checked with a few different values and it seems to be working.

 

[madocar]

Thanks HAZ