Spreadsheet: 159435d1338643719-how-to-look-up-two-cells-and-display-a-result-but-the-cells-to-look-up-are-not-constant-development_indirect-vlookup-_swing-ticket-test
Sheet: SwingTicketData

PrintshopID | DateInSystem | CustOrgID | CustPONumber | POCtrlNo | ShippingMethodCode | VendorRefCode | Courier | CourierAcctNo | VendorRef | ShipToOrgName | ShipToContactName | ShipToAddress1 | ShipToAddress2 | ShipToAddress3 | ShipToCity | ShiptoState | ShiptoZip | ShipToCountryCode | ShipToCountryName | ShipToPhone | [NAME] | ShipToEmail | VendorRef | DetailCtrlNo | SBOrigCode | CustItemCode | Quantity | UOM | OrderWeight | ItemCtrlID | SizeBlock | MSRP | UPC | InforLine1 | InfoLine2 | Story | zzDept | zzStroke | zzPrimarySize | zzPantoneCode | zzSecondarySize | [NAME]
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 100 |  |  |  | zzPrimarySize + lookup the corresponding pantone code | 25 | 8202635 | [NAME] | GREY MIX   16 | 0 | T32 Shapewear & Separates | 5089 | 16 |  | MINI | GREY MIX
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0
Z56 | 2012-05-31 00:00:00 |  |  |  | REGULAR | 8254 |  |  | 1063710 | [NAME] | [NAME] | [NAME] | Happy Street | Shatin | Hong Kong | 0 | 00000 | AQ | ANTARCTICA | 852-22339922 | 852-22339900 | [EMAIL] |  |  |  | ST/L2101OT | 0 |  |  |  |  | 25 | 0 |  | 0 | 0 | T32 Shapewear & Separates | 5089 | 0 |  | 0