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
Bookmarks