excelalways
New Member
- Joined
- Sep 8, 2013
- Messages
- 2
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.
<tbody>
</tbody>
Request you Excel gurus out there to please help me with this. Thanks in advance
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
