How do I look up a value in a separate table

[Mariano_de_los_Heros]

Hello!

In my model, I want to check the volume generated each month and assign it a cost per order based on a cost curve (see below). In Excel I would use a VLOOKUP or even an IF statement, but for Causal I am not sure how to do it.

Any ideas or suggestions?

[Mariano_de_los_Heros]

Sorry for the double post, I cannot attach two images in the same message. This is how the Volume variable looks like

[Sanjeev_Sandhar]

Hi Mariano,

My suggestion for how to approach this problem would be to create a separate Input Variable for each Cost per Order segment. i.e. Cost per Order - Volume Range (1-10) would be one such variable and you can assign the Cost you like.

Once you’ve created a variable for every segment you can then reference the variable in an IF statement. i.e. if volume >1 and volume <=10 then Cost per Order - Volume Range (1-10) else if volume >10 and volume <=20 then Cost per Order - Volume Range (11-20) etc.

[Mariano_de_los_Heros]

Thanks Sanjeev! I will follow your advice!