Search and VLookup

[AngelEyes6708]

I have two tables. One is a product table as shown below. The other is a transactional table, shown below the product table. The transactional table shows products purchased separated by a comma. I need to search the purchased products in the transactional table and replace with the short and long descriptions, separated by a comma, for each company. The short and long descriptions need to appear in their respective columns for each company separated by a comma. PLEASE HELP! THANK YOU!

Products	Prod Short Desc	Prod Long Desc
4	BRS	Brown Ridge Shirt
05	GRS	Green Ridge Shirt
07	HDM	Hot Denim Mass
10.HR	HRA	Hot Radiant Arches
PL-AB	PLA	Pretty Long Arches
TL	TL	Tall and Long

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

Company	Purchased	Prod Short Desc	Prod Long Desc
Company A	4,05,10.HR,PL-AB
Company B	05,07,TL,PL-AB
Company C	10.HR,4,07

<tbody>
</tbody><colgroup><col><col span="3"></colgroup>