Filter from descriptive cells items listed

[ranjit1964]

Dear Experts ,
Require help to extract from narration which includes name of an item which is listed seperately.

required info to be seen in cells of column e
Thanks
Ran

 

[vletm]

ranjit1964
As Your listed separately is same as Your required results
... then why You cannot use
... Your listed separately as required results?

 

[ranjit1964]

ranjit1964
As Your listed separately is same as Your required results
... then why You cannot use
... Your listed separately as required results?

Thanks for reply.
The real data is several lines , hence this requirement
best regards
Ran

 

[ranjit1964]

Dear VLETM & Experts,
Sorry i have not explained correctly.
The items in list-1 have to be looked up in column C of Narration sheet and result to be stated in column E
Thank you
Ran

 

[bosco_yip]

In "Narration" sheet E3, formula copied down :

=LOOKUP(1,-SEARCH('List-1'!$B$3:$B$6,C3),'List-1'!$B$3:$B$6)

Regards

 

[ranjit1964]

Thank you Bosco. It works.