Search Text in string and return a value from table

[krishnanshu]

Here is the table of raw data

Hi, I will call Sonia to come and get Nidhi from US for the party R u going to teach in the school, where Rashi is teaching Hi, I went to california and I saw Nidhi over there. I think she has shifted I would like to me Karl in office today <tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

I would like These words to be searched in sequential order from L1 to L4 column. If any found, return with value of L5 in new column

L1 L2 L3 L4 L5 Gopal Babu Venkat Nidhi Sunnyvale Sudeep Sameer Rashi Bala Los angeles Sonia Arun Satish Jeeda New York ABC Monika Karl MNO San Jose <colgroup><col><col><col><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[krishnanshu]

but how do i copy and then paste??

 

[krishnanshu]

Thanks, XOR

 

[XOR LX]

Thanks, XOR

Sure! Is everything working, then? Solved?

Regards

 

[krishnanshu]

Sure! Is everything working, then? Solved?

Regards

yup, Kind of... Might reach you to you for some more help

 

[XOR LX]

yup, Kind of... Might reach you to you for some more help

Sure. Though not quite sure what you mean by "kind of"?

Regards