Hi,
How to compare 2 list with find match and mismatch with formula. Can some help me.
Sheet4
<thead>
</thead><tbody>
</tbody>Excel 2007
How to compare 2 list with find match and mismatch with formula. Can some help me.
Sheet4
E | F | G | H | I | J | |
---|---|---|---|---|---|---|
1 | ||||||
2 | LED TRIM PANEL LIGHT 5W RD 6500K | 16 | Lts Glannz Solar 1.5w Led | 10 pcs | ||
3 | LED TRIM PANEL LIGHT ROUND 20W 6500K | 8 | LTS Solazen Led Solar Wall Light 3.2W Wh | 1 pcs | ||
4 | LED TRIM PANEL LIGHT SQUARE 20W 6500K | 8 | LED Trim Panel Light 5w RD 6500K | 16 pcs | ||
5 | LTS GAINZ SOLER 1.5W LED | 10 | LED Trim Panel Light Square 20W 6500K | 8 pcs | ||
6 | LTS RANGER 30 RECHARGE LED TORCH 3W | 10 | NU Bulb 10W865 B22 3 Star | 96 pcs | ||
7 | NUBULB 10W 865 B22 3 STAR | 96 | LED Trim Panel Light ROUND 20W 6500K | 8 pcs | ||
8 | WALL LIGHT STYLO UPTO 14W CGL B22 | 8 | LED Light Lumeno D/L 5W CDL RD | 12 pcs | ||
9 | Wall Light Stylo Upto 14W CFL B22 | 8 pcs | ||||
10 | LTS Ranger 3D Recharge LED Torch 3W | 10 pcs | ||||
11 |
<thead>
</thead><tbody>
</tbody>
Last edited: