Formula Help

[JMasters]

Need help making a formula work.

I have 5 columns of data, I need the input of "INV ITEM" to search in "LIST OF ITEMS" and return value of "ITEM" if contained in "LIST OF ITEMS" in "LEAD ITEM

[TABLE="width: 412"]
<tbody>[TR]
[TD]ITEM[/TD]
[TD]ALT ITEM[/TD]
[TD]LIST OF ITEMS[/TD]
[TD][/TD]
[TD]INV ITEM[/TD]
[TD]LEAD ITEM[/TD]
[/TR]
[TR]
[TD]A011[/TD]
[TD][/TD]
[TD]A011[/TD]
[TD][/TD]
[TD]A011[/TD]
[TD]A011[/TD]
[/TR]
[TR]
[TD]A064[/TD]
[TD]A062[/TD]
[TD]A064, A062[/TD]
[TD][/TD]
[TD]A062[/TD]
[TD]A064[/TD]
[/TR]
</tbody><colgroup><col span="2"><col><col span="3"></colgroup>[/TABLE]

 

[cebalaw2]

Assuming Item data begins in cell A2, set the formula in column E2 (Lead Item):
=IF(ISERROR(FIND(D2,C2,1)),"",A2)