Spreadsheet: 377729d1424143601-find-non-matching-value-in-rows-between-two-tables-change-in-code-combination
Sheet: Code Combos - Change in Level

2013 | OrgL1Code | OrgL2Code | OrgL3Code |  | 2014 | OrgL1Code | OrgL2Code | OrgL3Code | Result Column: Does this combination of codes (highlighted in red) exist in 2013? If not which level has changed (assuming only one level has changed)
 | INS | IID | UPN |  |  | INS | IID | UPN | Match - but what is the formula?
 | INS | IDP | EIC |  |  | INS | IIE | IIE | Match - but what is the formula?
 | INS | IDP | IST |  |  | INS | ICS | ICS | Match - but what is the formula?
 | INS | IRN | ILA |  |  | INS | III | III | Match - but what is the formula?
 | INS | IRN | IRC |  |  | INS | ISF | ISF | Match - but what is the formula?
 | INS | IRN | IRP |  |  | INS | IDP | EIC | Match - but what is the formula?
 | INS | IRN | IRB |  |  | INS | IDP | IDP | No Match: Result should show 'OrgL3Code' as IDP for this combo did not exist in 2013
 | INS | IRN | IRH |  |  | INS | IRN | IRN
 | INS | IRN | IRN |  |  | INS | IID | IID
 | INS | IRN | IRG |  |  | INS | IRN | ILA
 | INS | IRN | ILN |  |  | INS | IRN | ILN
 | INS | IRN | IRQ |  |  | INS | III | IIJ
 | INS | ISF | IRF |  |  | INS | III | IIN
 | INS | III | IIJ |  |  | INS | IRN | IRC
 | INS | IID | ISS |  |  | INS | IRN | IRG
 | INS | IID | IID |  |  | INS | IID | ISS
 | INS | IID | ILT |  |  | INS | IID | ILW
 | INS | IID | ILW |  |  | INS | IID | ILT
 | INS | IID | ILV |  |  | INS | IID | ILV
 | INS | ICS | IRM |  |  | INS | ICS | IRM
 | INS | ICS | REG |  |  | INS | ICS | REG
 | INS | ICS | IRS |  |  | INS | ICS | IRS
 | INS | ICS | IRR |  |  | INS | ICS | IRR
 | INS | ICS | IRT |  |  | INS | INS | INS
 | INS | ICS | ICS |  |  | INS | ICS | IFD
 | INS | INS | INS |  |  | INS | ICS | IRA
 | INS | III | IIM |  |  | INS | III | IIM
 | INS | III | IIB |  |  | INS | III | IIB
 | INS | IID | ILC |  |  | INS | III | IIP
 | INS | IIC | IIL |  |  | INS | III | IRV
 | INS | ISF | IIX |  |  | INS | ICS | IRT
 | INS | ISF | ISF |  |  | INS | IID | ILC
 | INS | IIC | IIT |  |  | INS | IIC | IIT
 | INS | IIC | IIC |  |  | INS | IRN | IRH
 | INS | IIC | IIW |  |  | INS | IRN | IRB
 | INS | IDP | IIO |  |  | INS | IIC | IIL
 | INS | IIE | IIE |  |  | INS | ISF | IIX
 | INS | III | IIP |  |  | INS | IIC | IIQ
 | INS | III | III |  |  | INS | IIC | IIW
 | INS | IIC | IIH |  |  | INS | IDP | IIO
 | INS | ICO | ICO |  |  | INS | ISF | IRF
 | INS | IID | IIU |  |  | INS | IIC | IIH
 | INS | III | IRV |  |  | INS | ISF | IFF
 | INS | III | IIK |  |  | INS | IDP | IIU
 | INS | III | IIN |  |  | INS | IDP | IST
 | INS | III | IIR |  |  | INS | IID | IIZ
 | INS | III | IIQ |  |  | INS | IID | IIG
 | UAD | PFS | FGC |  |  | INS | IIC | IIC
 | UAD | PFS | QUA |  |  | INS | III | IIK
 | UAD | PFS | FBT |  |  | INS | III | IIR
 | UAD | CLF | OMG |  |  | INS | IIC | IIF
 | UAD | CLF | OLG |  |  | UAD | PFS | FGC
 | UAD | CLF | OSB |  |  | UAD | PFS | FAC
 | UAD | PFS | RMB |  |  | UAD | CLF | OLG
 | UAD | OAA | SEC |  |  | UAD | CLF | OMG
 | UAD | CLF | ONA |  |  | UAD | CLF | OSB
 | UAD | CLF | DCB |  |  | UAD | PFS | RMB
 | UAD | CLF | DCT |  |  | UAD | PFS | RMA
 | UAD | CLF | DCO |  |  | UAD | CLF | ONA
 | UAD | CLF | DCA |  |  | UAD | CLF | DCB
 | UAD | OAA | SMO |  |  | UAD | CLF | DCT
 | UAD | OAA | ADO |  |  | UAD | CLF | DCO
 | UAD | OAA | EXT |  |  | UAD | CLF | DCA
 | UAD | OAA | GRD |  |  | UAD | PFS | TMS
 | UAD | PFS | TMS |  |  | UAD | PFS | FLG
 | UAD | PFS | FCS |  |  | UAD | PFS | FCS
 | UAD | PFS | FAC |  |  | UAD | CLF | OCC
 | UAD | CLF | OCC |  |  | UAD | CLF | ODC
 | UAD | OAA | PGC |  |  | UAD | CLF | OGC
 | GIC | GIC | GIC |  |  | UAD | PFS | [NAME]
 | UAD | PFS | RMA |  |  | UAD | PFS | RMC
 | UAD | OAA | ILG |  |  | UAD | PFS | RMI
 | UAD | OAA | SSN |  |  | UAD | PFS | COR
 | UAD | PFS | [NAME] |  |  | UAD | HRM | HRM
 | OVC | OVC | OVC |  |  | UAD | CLF | RSA
 | UAD | OAA | SSU |  |  | UAD | CLF | RSP
 | UAD | OAA | OAA |  |  | UAD | CLF | RSL
 | UAD | OAA | SMN |  |  | UAD | CLF | [NAME]
 | UAD | OAA | HSN |  |  | UAD | CLF | RSN
 | UAD | OAA | DSS |  |  | UAD | CLF | RSO
 | UAD | OAA | HSG |  |  | UAD | CLF | RSS
 | UAD | OAA | SAL |  |  | UAD | CLF | RSB
 | UAD | PVA | AUD |  |  | UAD | VPC | AUD
 | UAD | CLF | SHO |  |  | UAD | CLF | SHO
 | UAD | CLF | GFO |  |  | UAD | CLF | GFA
 | UAD | CLF | RCO |  |  | UAD | CLF | SHM
 | UAD | HRM | HRM |  |  | UAD | CLF | SHL
 | UAD | CLF | GFA |  |  | UAD | CLF | SHG
 | UAD | CLF | SHM |  |  | UAD | CLF | CSM
 | UAD | CLF | SHL |  |  | UAD | CLF | CHB
 | UAD | CLF | CSM |  |  | UAD | CLF | CSO
 | UAD | CLF | CHB |  |  | UAD | CLF | CSL
 | UAD | CLF | CSO |  |  | UAD | CLF | CSC
 | UAD | CLF | CSL |  |  | UAD | CLF | CSG
 | UAD | CLF | CSC |  |  | UAD | CLF | CSB
 | UAD | CLF | CSG |  |  | UAD | CLF | CSA
 | UAD | CLF | CSB |  |  | UAD | CLF | CSF
 | UAD | CLF | CSA |  |  | UAD | CLF | CSU
 | UAD | CLF | CSU |  |  | UAD | CLF | CSH
 | UAD | CLF | CSF |  |  | UAD | CLF | GFO
 | UAD | CLF | CSH |  |  | UAD | VPC | ORU
 | UAD | CLF | GFN |  |  | UAD | PFS | QUA
 | UAD | PVA | ORU |  |  | UAD | PFS | FBT
 | UAD | PFS | RMS |  |  | UAD | PFS | RMS
 | UAD | PVA | PVA |  |  | UAD | PFS | PLN
 | UAD | PFS | COR |  |  | UAD | PFS | DFB
 | UAD | CLF | ODC |  |  | UAD | PFS | RMH
 | UAD | PFS | RMH |  |  | UAD | CLF | GFN
 | UAD | PFS | RMI |  |  | UAD | CLF | RCO
 | UAD | CLF | OGC |  |  | UAD | PFS | FIN
 | UAD | CLF | RAC |  |  | UAD | VPC | VPC
 | UAD | CLF | RAH |  |  | UAD | VPC | PVA
 | UAD | CLF | RCS |  |  | UAD | PFS | TRN
 | UAD | CLF | RAO |  |  | UAD | PFS | ABS
 | UAD | PFS | FLG |  |  | UAD | VPC | LSV
 | UAD | OAA | HON |  |  | UAD | CLF | RAC
 | UAD | PFS | FIN |  |  | UAD | CLF | RAH
 | UAD | PFS | DFB |  |  | UAD | CLF | RCS
 | UAD | PFS | PLN |  |  | UAD | CLF | RAO
 | UAD | PFS | ABS |  |  | UAD | CLF | XTS
 | UAD | OAA | GSB |  |  | UAD | PFS | MAD
 | UAD | CLF | RSA |  |  | UAD | VPC | RBC
 | UAD | CLF | RSO |  |  | SCG | SET | SCH
 | UAD | CLF | RSS |  |  | SCG | SET | BPS
 | UAD | CLF | RSN |  |  | SCG | SET | MBF
 | UAD | CLF | RSP |  |  | SCG | SET | TCL
 | UAD | CLF | RSB |  |  | SCG | SET | PVS
 | UAD | CLF | RSL |  |  | SCG | SET | SSW
 | UAD | CLF | [NAME] |  |  | SCG | SET | MNC
 | UAD | PVA | LSV |  |  | SCG | SET | QMF
 | UAD | PFS | MAD |  |  | SCG | SET | IGN
 | UAD | PFS | RMC |  |  | SCG | SET | GDC
 | UAD | CLF | XTS |  |  | SCG | SET | IGG
 | UAD | PFS | TRN |  |  | SCG | SET | IGF
 | UAD | CLF | [NAME] |  |  | SCG | SET | IGA
 | UAD | CLF | GFQ |  |  | SCG | SET | IGC
 | UAD | PVA | RBC |  |  | SCG | SET | IGB
 | UAD | OAA | [NAME] |  |  | SCG | SET | IGM
 | UAD | OAA | SMG |  |  | SCG | SET | GRH
 | UAD | OAA | STO |  |  | SCG | SET | EFC
 | SCG | SET | SCH |  |  | SCG | SET | FFC
 | SCG | SET | BPS |  |  | SCG | SET | EPH
 | SCG | SET | MBF |  |  | SCG | SET | ENV
 | SCG | SET | CQD |  |  | SCG | SET | CUR
 | SCG | SET | ANI |  |  | SCG | SET | ICT
 | SCG | SET | TCL |  |  | SCG | SET | ISY
 | SCG | SET | PVS |  |  | SCG | SET | ECM
 | SCG | SET | EWS |  |  | SCG | SET | ESK
 | SCG | SET | NEU |  |  | SCG | SET | NEU
 | SCG | SET | MNC |  |  | SCG | SET | ARI
 | SCG | SET | QMF |  |  | SCG | SET | EAU
 | SCG | SET | IGN |  |  | SCG | SET | ENG
 | SCG | SET | GDC |  |  | SCG | SET | CER
 | SCG | SET | IGF |  |  | SCG | SET | WMA
 | SCG | SET | IGA |  |  | SCG | SET | ECO
 | SCG | SET | IGC |  |  | SCG | SET | ENS
 | SCG | SET | IGB |  |  | SCG | SET | NCC
 | SCG | SET | IGG |  |  | SCG | SET | CQD
 | SCG | SET | IGM |  |  | SCG | SET | FUE
 | SCG | SET | EFC |  |  | SCG | SET | ANI
 | SCG | SET | EPH |  |  | SCG | SET | CLC
 | SCG | SET | ARI |  |  | SCG | SET | CCA
 | SCG | SET | ICT |  |  | GIC | CAL | CBN
 | SCG | SET | MWS |  |  | GIC | CAL | CXN
 | SCG | SET | ECM |  |  | GIC | CAL | CBG
 | SCG | SET | ENV |  |  | GIC | GEP | GEP
 | SCG | SET | FUE |  |  | GIC | GIC | GGA
 | SCG | SET | ESK |  |  | GIC | GIC | GIC
 | SCG | SET | FFC |  |  | GIC | GIC | GSI