Hi,

I have a list of data I'd like to search using a specific word and return the adajcent word. e.g. in cell b2 I have a name of an organization: The Example Organization. If I am searching for "organization," I want the function to return "Example."

Can anyone give me some guidance?