How to IF multiple options

[Loesky]

Hi,

I have a problem where I have price data from one company and want to allign it to our products. Basically saying, if product A falls under these measurements it is in group 1. If Product A is in group 1 and has a weight of 1 KG the price is 1,00 but if the product is 2 KG the price is 2,00.
I have already have a formula for this for when there is only one weight and price option; =IF(T3= TRUE; $AI$2; FALSE) but this does not apply for when there are multiple weight and price options.

Added a picture in the hopes it makes more sense. Thank you in advance!

 

[jkpieterse]

Have a look at the XLOOKUP function (X.ZOEKEN in Dutch Excel) or, alternatively if you're on an older version: VLOOKUP (VERT.ZOEKEN)

 

[Loesky]

Have a look at the XLOOKUP function (X.ZOEKEN in Dutch Excel) or, alternatively if you're on an older version: VLOOKUP (VERT.ZOEKEN)

Not sure if that will work since there has to be an condition met of the weight.

 

[jkpieterse]

You can do a lookup on two or more columns by joining them, example:
=XLOOKUP(A1&"|"&B1,$C$2:$C$100&"|"$D$2:$D$200,$F$2:$F$200)