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.
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 |