VLOOKUP equivilent?


I’m currently creating a cabinet handle as a dynamic component - it is available from the manufacturer in 4 different sizes - depth and width differ with each. I have created a drop down option for the width (which is how the manufacturer differentiates between the sizes), but is there a way to create a function that auto selects the depth dependent on which width has been selected?

For example, if the user selects handle width as 38mm, the component needs to auto select the depth at 25mm.

In excel, I would use a VLOOKUP function for the same effect.

Many thanks

Perhaps the depth attribute formula …

=CHOOSE(OPTIONINDEX("Width"), 100, 150, 200)