Hello Gurus.
I have a set of data that contains serial numbers, models, and compartments. In addition I have a master list that contains what compartments should be associated with what models. This issue Im having is that I need to know which compartments are missing from each serial number. This put me into a double lookup scenario where I need to find the model in the master list, then tell me what compartments are missing in the actual data.
<COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><TBODY>
</TBODY>
Here is what Im hoping to accomplish:
<COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><TBODY>
</TBODY>
All my code to this point has failed. Any help is most appreciated. Thank you.
I have a set of data that contains serial numbers, models, and compartments. In addition I have a master list that contains what compartments should be associated with what models. This issue Im having is that I need to know which compartments are missing from each serial number. This put me into a double lookup scenario where I need to find the model in the master list, then tell me what compartments are missing in the actual data.
Actual Data | Master List | ||||
Serial | Model | COMPARTMENT | MODEL | COMPARTMENT | |
18742 | 305CR | ENG | 305CR | ENG | |
18742 | 305CR | HS | 305CR | FD_RR_LT | |
2201056 | 815F | ENG | 305CR | FD_RR_RT | |
247 | MT765 | DIFF_RR | 305CR | FS | |
247 | MT765 | ENG | 305CR | HS | |
247 | MT765 | FD_RR_LT | 305CR | RA | |
247 | MT765 | FD_RR_RT | 815F | DIFF_FR | |
247 | MT765 | FS | 815F | DIFF_RR | |
247 | MT765 | HS | 815F | ENG | |
247 | MT765 | RA | 815F | FD_FR_LT | |
247 | MT765 | ST_SYS | 815F | FD_FR_RT | |
247 | MT765 | TR_PW_SH | 815F | FD_RR_LT | |
815F | FD_RR_RT | ||||
815F | FS | ||||
815F | HS | ||||
815F | RA | ||||
815F | TR_PW_SH | ||||
MT765 | DIFF_RR | ||||
MT765 | ENG | ||||
MT765 | FD_RR_LT | ||||
MT765 | FD_RR_RT | ||||
MT765 | FS | ||||
MT765 | HS | ||||
MT765 | RA | ||||
MT765 | ST_SYS | ||||
MT765 | TR_PW_SH |
<COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><TBODY>
</TBODY>
Here is what Im hoping to accomplish:
Actual Data | |||
Serial | Model | COMPARTMENT | |
18742 | 305CR | ENG | ENG |
18742 | 305CR | HS | HS |
FD_RR_LT | |||
FD_RR_RT | |||
FS | |||
RA | |||
2201056 | 815F | ENG | ENG |
DIFF_RR | |||
FD_FR_LT | |||
FD_FR_RT | |||
FD_RR_LT | |||
FD_RR_RT | |||
FS | |||
HS | |||
RA | |||
TR_PW_SH | |||
DIFF_FR | |||
247 | MT765 | DIFF_RR | DIFF_RR |
247 | MT765 | ENG | ENG |
247 | MT765 | FD_RR_LT | FD_RR_LT |
247 | MT765 | FD_RR_RT | FD_RR_RT |
247 | MT765 | FS | FS |
247 | MT765 | HS | HS |
247 | MT765 | RA | RA |
247 | MT765 | ST_SYS | ST_SYS |
247 | MT765 | TR_PW_SH | TR_PW_SH |
<COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3876" width=106><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><TBODY>
</TBODY>
All my code to this point has failed. Any help is most appreciated. Thank you.