Hi everyone,

I need a formula that will search for the person's name and then search for a specific text string in the adjacent column (e.g. "commitment:") and bring me the row that contains that text string. I pasted the image with desired result below. I know how to do this bringing the text string cell in order of appearance but I really want to tie this to the person's name in case they switch orders.

Hope someone can help!


excel example.JPG