Populate Cells based on multiple 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 based on the same company name and where ever the ICODE <> 49.

​	CURRENT SHEET	​	​	​	​	​
ICODE	PRODUCT	COMPANY	AD1	AD2	AD3	AD4
89​	PENS	ABC STATIONERY CO LLC	​	​	​	​
49​	PENCILS	ABC STATIONERY CO LLC	​	​	​	​
49​	ERASER	ABC STATIONERY CO LLC	​	​	​	​
94​	OVEN	WORLD *******WARE	​	​	​	​
90​	CABINETS	WORLD *******WARE	​	​	​	​
49​	COOKING RANGE	WORLD *******WARE	​	​	​	​
49​	STAINLESS STEEL TABLE	WORLD *******WARE	​	​	​	​
49​	DISHWASHER	WORLD *******WARE	​	​	​	​
91​	TABLES	GENUINE FURNITURE SUPPLIES	​	​	​	​
49​	CHAIRS	GENUINE FURNITURE SUPPLIES	​	​	​	​
89​	PIPES	RELIABLE PLASTICS CO	​	​	​	​
90​	CHAIRS	RELIABLE PLASTICS CO	​	​	​	​
24​	BUCKET	RELIABLE PLASTICS CO	​	​	​	​
93​	TABLES	RELIABLE PLASTICS CO	​	​	​	​
49​	TOYS	RELIABLE PLASTICS CO	​	​	​	​
49​	BOTTLES	RELIABLE PLASTICS CO	​	​	​	​
​	​	​	​	​	​	​
​	FINAL REQUIRED SHEET	​	​	​	​	​
ICODE	PRODUCT	COMPANY	AD1	AD2	AD3	AD4
89​	PENS	ABC STATIONERY CO LLC	​	​	​	​
49​	PENCILS	ABC STATIONERY CO LLC	PENS	​	​	​
49​	ERASER	ABC STATIONERY CO LLC	PENS	​	​	​
94​	OVEN	WORLD *******WARE	​	​	​	​
90​	CABINETS	WORLD *******WARE	​	​	​	​
49​	COOKING RANGE	WORLD *******WARE	OVEN	CABINETS	​	​
49​	STAINLESS STEEL TABLE	WORLD *******WARE	OVEN	CABINETS	​	​
49​	DISHWASHER	WORLD *******WARE	OVEN	CABINETS	​	​
91​	TABLES	GENUINE FURNITURE SUPPLIES	​	​	​	​
49​	CHAIRS	GENUINE FURNITURE SUPPLIES	TABLES	​	​	​
89​	PIPES	RELIABLE PLASTICS CO	​	​	​	​
90​	CHAIRS	RELIABLE PLASTICS CO	​	​	​	​
24​	BUCKET	RELIABLE PLASTICS CO	​	​	​	​
93​	TABLES	RELIABLE PLASTICS CO	​	​	​	​
49​	TOYS	RELIABLE PLASTICS CO	PIPES	CHAIRS	BUCKET	TABLES
49​	BOTTLES	RELIABLE PLASTICS CO	PIPES	CHAIRS	BUCKET	TABLES

<tbody>
</tbody>

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