Creating dynamic loop instead of using nested if

image

Hello everyone,

According to the data in the first table you see above, I need to make the selections in the second table.

I can do this in a simple way using nested if. But what would I do if there were more than 100 options here?

How can I make this situation dynamic?

Thanks!

Load the second sheet into a DT then you can use a Select to get the value you want.