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
Check out the Formula Handbook template!