Spreadsheet: 86470d1286445285-use-an-array-formula-to-perform-a-two-or-more-criteria-lookup-in-excel-worksheet
Sheet: Sheet1

Customer | Country | Invoice No. | PIC | Inv Amount |  | [NAME] | BL Date | Vsl/Flight No. | POL | POD | Term | Tenor |  | L/C No.
DHANYA | UAE | 1001372 | DIANA | USD | 38395.8 |  | 2010-01-22 00:00:00 | ALEXANDRIA BRIDGE V.003W | SIN | DUBAI | FOB | TT
INDUS MOTOR | PAKISTAN | 1001653 | IRIS | USD | 79669.05 |  | 2010-02-02 00:00:00 | ACX RAFFLESIA V.044W | LAEM CHABANG, THAILAND | BIN QASIM PORT, PAKISTAN | CNF | LC | AT SIGHT | LC/01/052/32134
TTHK | CAMBODIA | 1002283 | IRIS | USD | 1352.21 |  | 2010-02-09 00:00:00 | SWAN RIVER BRIDGE V.002S / KITI BHUM V.642N | BKK | PHNOM PENH | CIF | TT
INDUS MOTOR | INDIA | 1002308 | IRIS | USD | 116115.96 |  | 2010-02-06 00:00:00 | ACX CRYSTAL V.015W | LAEM CHABANG, THAILAND | BIN QASIM PORT, PAKISTAN | CNF | LC | AT SIGHT | LC/01/052/32134
INDUS MOTOR | PAKISTAN | 1002378 | IRIS | USD | 102743.61 |  | 2010-02-13 00:00:00 | ACX MARGUERITE V.092W | LAEM CHABANG, THAILAND | BIN QASIM PORT, PAKISTAN | CFR | LC | AT SIGHT | LC/01/052/32134
INDUS MOTOR | PAKISTAN | 1002616 | IRIS | USD | 48174.26 |  | 2010-02-20 00:00:00 | ACX SALVIA V.008W | LAEM CHABANG, THAILAND | BIN QASIM PORT, PAKISTAN | CFR | LC | AT SIGHT | LC/01/052/32134 | 4225411.689999999
INDUS MOTOR | PAKISTAN | 1002638 | IRIS | USD | 34659.55 |  | 2010-02-27 00:00:00 | ACX HIBISCUS V.049W | LAEM CHABANG, THAILAND | BIN QASIM PORT, PAKISTAN | CFR | LC | AT SIGHT | LC/01/052/32134
TTC (NGY) | JAPAN | 1003137 | IRIS | USD | 2366.1 |  | 2010-02-23 00:00:00 | PHUKET BRIDGE V.223N | BKK | NGY | CIF | TT | 25 DAYS AFTER ETD
HINOPAK MOTORS | PAKISTAN | 1003164 | DIANA | [NAME] | 1960000 |  | 2010-03-16 00:00:00 | ACX RAFFLESIA V.045W | SINGAPORE | KARACHI SEAPORT | CFR | LC | AT SIGHT | LC/01/023/7657
HINOPAK MOTORS | PAKISTAN | 1003165 | DIANA | [NAME] | 1960000 |  | 2010-03-16 00:00:00 | ACX RAFFLESIA V.045W | SINGAPORE | KARACHI SEAPORT | CFR | LC | AT SIGHT | LC/01/023/7657
INDUS MOTOR | PAKISTAN | 1003365 | IRIS | USD | 61.44 |  | 2010-03-12 00:00:00 | DHL | MANILA, PHILIPPINES | KARACHI AIRPORT, PAKISTAN | CFR | LC | AT SIGHT | LC/01/052/32134
INDUS MOTOR | PAKISTAN | 1003374 | IRIS | USD | 34053.01 |  | 2010-03-13 00:00:00 | ACX RAFFLESIA V.045W | LAEM CHABANG, THAILAND | BIN QASIM PORT, PAKISTAN | CNF | LC | AT SIGHT | LC/01/052/32134
INDUS MOTOR | PAKISTAN | 1003468 | IRIS | USD | 45457.57 |  | 2010-03-20 00:00:00 | ACX CRYSTAL V.016W | LAEM CHABANG, THAILAND | BIN QASIM PORT, PAKISTAN | CFR | LC | AT SIGHT | LC/01/052/32134
MANOJ CHEM | INDIA | 10010011 | WENDY | USD | 26520 | 2010-01-11 00:00:00 | 2010-01-04 00:00:00 | MOL ENCORE V.13058 | TOKYO, JAPAN | ICD DELHI TKD VIA NHAVA SHEVA | CIF | LC | 90 DAYS FROM BL DATE | 6700FLCDA090038
KONG NUON | CAMBODIA | 10010244 | DIANA | USD | 158500.4 |  | 2010-01-13 00:00:00 | BY TRUCK | ARANYAPRATHET, THAILAND | POIPET, CAMBODIA | CIP | LC | 90 DAYS AFTER TWB DATE | KLC201001004
INDOFIL | INDIA | 10010254 | YOUYOONG | USD | 62480 |  | 2010-01-13 00:00:00 | [NAME] V.W057 | JAKARTA, INDONESIA | NHAVA SHEVA PORT, INDIA | CIF | LC | 90 DAYS FROM B/L DATE | 144IMLU100060001
KALITE LASTIK | TURKEY | 10010309 | WENDY | USD | 30840 |  | 2010-01-21 00:00:00 | NYK VESTA V.18W03 | TOKYO, JAPAN | ISTANBUL, TURKEY | CIF | LC | 60 DAYS AFTER COMMERCIAL INVOICE DATE | 952 1109001A
INDOFIL | INDIA | 10020070 | YOUYOONG | USD | 32191.5 |  | 2010-02-04 00:00:00 | SANTA FEDERICA V.705 / CAPE CAMPBEL V.W001 | JAKARTA, INDONESIA | NHAVA SHEVA PORT, INDIA | CIF | LC | 90 DAYS FROM B/L DATE | 144IMLU100280001
INDOFIL | INDIA | 10020071 | YOUYOONG | USD | 32224.5 |  | 2010-02-04 00:00:00 | SINAR SABANG V.066 | JAKARTA, INDONESIA | NHAVA SHEVA PORT, INDIA | CIF | LC | 90 DAYS FROM B/L DATE | 144IMLU100280001
KONG NUON | CAMBODIA | 10020090 | DIANA | USD | 189773.61 |  | 2010-02-02 00:00:00 | BY TRUCK | ARANYAPRATHET, THAILAND | POIPET, CAMBODIA | CIP | LC | 90 DAYS AFTER TWB DATE | KLC201001017
ADVANCE POLYMERS | DURBAN | 10020294 | CONSTANCE | USD | 66960 |  | 2010-02-10 00:00:00 | POSEN V.011W / MOL WISDOM V.3931A | PENANG, MALAYSIA | DURBAN, SOUTH AFRICA | CFR | LC | 90 DAYS FROM TRANSPORT DOCUMENT DATE | I657/5026474/DLC
MACHINO POLYMERS | INDIA | 10020346 | PEGGY | USD | 124500 |  | 2010-02-12 00:00:00 | APL ARGENTINA V.056W | SINGAPORE | NHAVA SHEVA | CIF | LC | 150 DAYS FROM BL DATE | 0189110FLU000014
CHI YA FOAM ENTERPRISE | VIETNAM | 10020391 | YOUYOONG | USD | 24000 |  | 2010-02-23 00:00:00 | ASTA RICKMERS V.0H309R | PORT KLANG, MALAYSIA | HOCHIMINH PORT, VIETNAM | CIF | LC | 90 DAYS FROM B/L DATE | 907IUSN100410001
MACHINO POLYMERS | INDIA | 10020754 | PEGGY | USD | 54000 |  | 2010-02-27 00:00:00 | THOMAS MANN V.024W | SINGAPORE | NHAVA SHEVA | CIF | LC | 150 DAYS FROM BL DATE | 0189110FLU000014 | 78000
RAM CHARAN | INDIA | 10030292 | CONSTANCE | USD | 30738 |  | 2010-03-15 00:00:00 | [NAME] V.16068 | TOKYO, JAPAN | NHAVA SHEVA | CIF | LC | 90 DAYS FROM BL DATE | 2511FLC4018/10
EM-POL | PHILIPPINES | 10030294 | YOUYOONG | USD | 37770.1 |  | 2010-03-15 00:00:00 | SANYA V.022W / RESOURCEFUL V.88N | JAKARTA, INDONESIA | MANILA, PHILIPPINES | CIF | LC | 30 DAYS AFTER B/L DATE | 00407010031653
ADVANCE POLYMERS | DURBAN | 10030296 | CONSTANCE | USD | 68400 |  | 2010-03-02 00:00:00 | [NAME] YORK V.H1009A | PENANG, MALAYSIA | DURBAN, SOUTH AFRICA | CFR | LC | 90 DAYS FROM TRANSPORT DOCUMENT DATE | I657/5026697/DLC
INDOFIL | INDIA | 10030344 | YOUYOONG | USD | 72150 |  | 2010-03-25 00:00:00 | SINAR SABANG V.073 / HYUNDAI PROGRESS V.248W | JAKARTA PORT, INDONESIA | NHAVA SHEVA PORT, INDIA | CIF | LC | 90 DAYS FROM B/L DATE | 144IMLU100640001 | 209058.1
MACHINO POLYMERS | INDIA | 10040413 | PEGGY | USD | 204900 |  | 2010-04-17 00:00:00 | POSEN V.014W | SINGAPORE | NHAVA SHEVA | CIF | LC | 150 DAYS FROM BL DATE | 0189110FLU000035