Fill in values based on 2 column criteria

[excelalways]

Hi Guys,

Im struggling to find a formula to populate cells based on values to be checked in two fields (ICODE, COMPANY).
In the example shown, all records where ever the ICODE = 49, i need to populate the fields AD1,AD2,AD3 or AD4 with the Product Name of the same company name but only where the ICODE <> 49.

Request you Excel gurus out there to please help me with this. Thanks in advance

​	CURRENT SHEET	​	​	​	​	​
ICODE	PRODUCT	COMPANY	AD1	AD2	AD3	AD4
89​	PENS	ABC STATIONERY	​	​	​	​
49​	PENCILS	ABC STATIONERY	​	​	​	​
49​	ERASER	ABC STATIONERY	​	​	​	​
94​	OVEN	W. *******WARE	​	​	​	​
90​	CABINETS	W. *******WARE	​	​	​	​
49​	COOKING RANGE	W. *******WARE	​	​	​	​
49​	S. S. TABLE	W. *******WARE	​	​	​	​
49​	DISHWASHER	W. *******WARE	​	​	​	​
91​	TABLES	GEN. FURNITURE	​	​	​	​
49​	CHAIRS	GEN. FURNITURE	​	​	​	​
89​	PIPES	RELIABLE PLASTICS	​	​	​	​
90​	CHAIRS	RELIABLE PLASTICS	​	​	​	​
24​	BUCKET	RELIABLE PLASTICS	​	​	​	​
93​	TABLES	RELIABLE PLASTICS	​	​	​	​
49​	TOYS	RELIABLE PLASTICS	​	​	​	​
49​	BOTTLES	RELIABLE PLASTICS	​	​	​	​
​	​	​	​	​	​	​
​	FINAL REQUIRED SHEET	​	​	​	​	​
ICODE	PRODUCT	COMPANY	AD1	AD2	AD3	AD4
89 ​	PENS	ABC STATIONERY	​	​	​	​
49​	PENCILS	ABC STATIONERY	PENS	​	​	​
49​	ERASER	ABC STATIONERY	PENS	​	​	​
94​	OVEN	W. *******WARE	​	​	​	​
90​	CABINETS	W. *******WARE	​	​	​	​
49​	COOKING RANGE	W. *******WARE	OVEN	CABINETS	​	​
49​	S.S. TABLE	W. *******WARE	OVEN	CABINETS	​	​
49​	DISHWASHER	W. *******WARE	OVEN	CABINETS	​	​
91​	TABLES	GEN. FURNITURE	​	​	​	​
49​	CHAIRS	GEN. FURNITURE	TABLES	​	​	​
89​	PIPES	RELIABLE PLASTICS	​	​	​	​
90​	CHAIRS	RELIABLE PLASTICS	​	​	​	​
24​	BUCKET	RELIABLE PLASTICS	​	​	​	​
93​	TABLES	RELIABLE PLASTICS	​	​	​	​
49​	TOYS	RELIABLE PLASTICS	PIPES	CHAIRS	BUCKET	TABLES
49​	BOTTLES	RELIABLE PLASTICS	PIPES	CHAIRS	BUCKET	TABLES

<tbody>
</tbody>