I would like to search in a parant/child and get the result from another column

In the example you see BE and IT, with specific items. I'm looking for example for BE, item 4 and then want to see result mail 2, or IT, item 6 result mail 5.

I tried index and match but I can't get it too work, does anybody have an idea how to solve this?

Thx for your support



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!