How to find in a particular column and place the result in separate column

[Aggsneh]

Hi all,

I am working on one of the file wherein I need to find some names in a particular column from list of names and need to place the results in new column. Would be helpful if anyone can help me out. Attaching sample date for your reference.

[pedrodrfaria · Accepted solution]

 Hi @Aggsneh 

Based on what you sent, all the names were found in the dataset. See below using a find and replace logic to flag the fields with the name being matched.

Is this what you were looking for?

Pedro.

[echuong1 · Accepted solution]

If I understand your requirements, you're trying to identify the description rows that contain one of the keyword names? If so, you can use a find and replace to search the description field for the keyword. I've appended it to a new column. Anything that matched would have a name field filled in.

I used a filter to separate out those that didn't match. Hope this helps!

[Qiu · Accepted solution]

@Aggsneh 

Is this what you need?