If you are willing to use Power Query, then you can join the two tables on a common field. Here is the Mcode and attached file
Data Range
|
A |
B |
C |
1 |
ASSETNUM |
Table2.Column2 |
Table2.Column3 |
2 |
CB3001981 |
1110909 |
MODULE:POWER SUPPLY,110/230VAC,6118,OMNI |
3 |
CB3001977 |
1112060 |
DETECTOR,FLAME:-60 TO 85deg C;24V;DC> |
4 |
CB3001980 |
1112060 |
DETECTOR,FLAME:-60 TO 85deg C;24V;DC> |
5 |
CB3001981 |
1112060 |
DETECTOR,FLAME:-60 TO 85deg C;24V;DC> |
6 |
CB3001980 |
1112471 |
MODULE:COMBO-A,INPUT/OUTPUT,6006,OMNI |
7 |
CB3001980 |
1112493 |
MODULE:SERIAL/ETHERNET-MODBUS MUX,6209,> |
Bookmarks