I have two lists of data and I have to transfer some of the information from one list to the other one. In this case, I need to transfer the information from "column J – Table 2" to "column F – Table 1". I have groupings called test sets (C0110, C011, C012, C013,C014,C015,C035) and they are unique. Test sets are made up of test codes and the test codes can be part of different test sets.
Test Set C010 is made up of:
C1220
C1230
C1250
C1260
C1269
C1000
C1160
C1170
C1195
C1196
C1190
C1290
C1400
C1410
C1420
C1430
C1480
C1510
C1550
C1570
Test Set C011 is made up of:
C1220
C1230
C1250
C1260
C1269
C1000
C1160
C1170
C1195
C1196
C1290
C1190
The test codes can have different settings depending on the test set. Such is the information that I am trying to transfer from Table 2 to Table 1. C1220 in Test Set C010 in Column J has a setting of M and the same test code in test set C011 has a setting of O. I tried using VLOOKUP to transfer the information in Column J based on the test code, but it brings over the value in column J of the first match of the test code. In this case, it sets test code C1220 as M for all of the test tests. What other function can I use so that it grabs the value in the J column that belongs to the specific test set?
I have attached the spreadsheet with the formula I used.
Bookmarks