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
<tbody>
ITEM
ALT ITEM
LIST OF ITEMS
INV ITEM
LEAD ITEM
A011
A011
A011
A011
A064
A062
A064...