Spreadsheet: 742723d1627992053-how-to-vlook-up-based-on-the-content-of-an-excel-cell-zenith-august-payment-schedule
Sheet: TECH.SHORTLIST

ZENITH SUPPLIERS SHORTLIST
 | Name | Sum of Year 2019 Excl Skylight | Sum of 1st+2nd Quarter 2020 Excl Skylight | Sum of 3rd Quarter 2020 Excl Skylight | Sum of 4th Quarter 2020 Excl Skylight | Sum of 1st Quarter 2021 [NAME] | Sum of TOTAL
 | KOYO INSTRUMENTS & INDUSTR.CO-TECHNOMAR | 115826.87 | 123932.13 | 36681.98 | 4444.66 | 4054.67
 | JEONG KOREA ENGINE CO.,LTD | 110388.27 | 75906.28 | 36258.88 | 29126.95 | 26206.87
 | METALOCK ENGINEERING (QINGDAO) LTD | 37395 | 0 | 0 | 0 | 0
 | METALOCK (HONG KONG) CO., LTD | 34385 | 33600 | 52252.17 | 5200 | 1215.35
 | J.N.E MARINE LTD-TECHNOMAR | 22043.37 | 11272.72 | 9434.18 | 0 | 343.57
 | SHANGHAI ELIHU MARINE SERVICE CO., LTD | 21514 | 8103 | 15187 | 1815 | 2128
 | RMS MARINE SERVICE CO | 17894.04 | 140421.31 | 35957.41 | 35572.45999999999 | 7585.17
 | HSANGHAI MARINE SERVICES-TECHNOMAR | 10788 | 7140 | 26510.5 | 2350 | 2656
 | CHIEFMAR S.R.L | 7403.15 | 0 | 0 | 0 | 0
 | SEA POWER AG | 4016.22 | 27636.86 | 2761.92 | 3355.01 | 1255.23
 | KONGSBERG MARITIME CHINA (SHANGHAI) LTD | 3439 | 0 | 0 | 0 | 0
 | AEOLIKI MARINE LTD -  HONG KONG | 3070.84 | 1124.34 | 0 | 0 | 0
 | I.M.A. ELECTRONICS LTD | 2713.81 | 0 | 0 | 0 | 0
 | MARINE INDUSTRY INC.-TECHNOMAR.  (DAIHATSU) | 919.3300000000036 | 23834.04 | 0 | 0 | 0
 | BOILERMAN SERVICE INTERNATIONAL LTD | 720 | 0 | 0 | 2050 | 166
1 | A.P.& A. MARITIME LIMITED | 0 | 13252.4 | 7471.559999999999 | 15812.55 | 2926.47
 | AEOLIKI MARINE LTD | 0 | 225 | 0 | 241.76 | 2245.47
 | AGILE ENGINEERING LTD | 0 | 0 | 7996 | 0 | 0
 | ALATAS SINGAPORE PTE LTD-TECHNOMAR | 0 | 0 | 0 | 308 | 2981.62
 | ALFA LAVAL AEBE | 0 | 0 | 0 | 3804.46 | 0
 | BUREAU VERITAS HELLAS S.A. | 0 | 2934.48 | 986 | 0 | 0
 | [NAME] | 0 | 15055.08 | 15846.22 | 1596.36 | 19871.16
 | DCS POWER PTE LTD | 0 | 0 | 0 | 0 | 7095
 | [NAME] | 0 | 1273.33 | 2423.89 | 3450.74 | 0
 | DESIN MARINE & INDUSTRY SERVICES LTD | 0 | 15740 | 8280 | 4100 | 0
 | DIESEL MARINE INTERNATIONAL -TECHNOMAR- | 0 | 0 | 0 | 14736 | 0
 | DIESELMAN MARINE SERVICE CO., LTD | 0 | 0 | 15609 | 8824 | 0
 | DIESELMAN MARINE SINGAPORE PTE LTD | 0 | 0 | 0 | 0 | 1127.5
 | DREW MARINE | 0 | 2310 | 0 | 1257.75 | 2928.75
 | ERMA FIRST ESK ENGINNERING SOLUTIONS SA | 0 | 0 | 0 | 11096.17 | 0
 | EUPLOIA DRYDOCKS&SERVICES LTD | 0 | 0 | 12119.68 | 0 | 0
 | FRANMAN - TECHNOMAR | 0 | 0 | 0 | 0 | 18840.31
 | FURUNO HELLAS LTD | 0 | 0 | 20748.57 | 15562.73 | 10335.61
 | HEMPEL COATINGS (HELLAS) S.A | 0 | 0 | 0 | 23900.69 | 0
 | JOWA (S) PTE LTD | 0 | 0 | 0 | 2243 | 0
 | JOWA HELLAS EPE | 0 | 1960.24 | 789.26 | 2114.12 | 0
 | JUNMA SERVICES PTE LTD | 0 | 0 | 23717.56 | 22236.05 | 0
 | KET MARINE INTERNATIONAL B.V. | 0 | 0 | 5491.04 | 0 | 4609.65
 | KONGSBERG MARITIME BENELUX BV | 0 | 951.36 | 16853.78 | 633.4499999999999 | 0
 | KONGSBERG MARITIME CM AS | 0 | 0 | 0 | 17856.85 | 0
 | MAN ENERGY SOLUTIONS HELLAS LTD | 0 | 0 | 0 | 31603.62 | 0
 | MEKNAFT - TECHNOMAR | 0 | 35873.5 | 0 | 0 | 112.68
 | METALOCK BRASIL LTDA | 0 | 0 | 0 | 0 | 14032.01
 | METLOCAST HELLAS EPE-TECHNOMAR | 0 | 0 | 0 | 10470.24 | 0
 | RMS MARINE & OFFSHORE SERVICE (SPORE) PTE LTD | 0 | 51231.85000000001 | 22042.99 | 53088.27 | 3102
 | RMS MARINE SERVICE B.V. | 0 | 0 | 22313.9 | 2483.65 | 0
 | SCHELDE MARINE SERVICES - TECHNOMAR | 0 | 786.8599999999999 | 0 | 7579.42 | 0
 | SENDA (S) PTE LTD | 0 | 184 | 690 | 5325 | 20902.8
 | SKF MARINE GMBH | 0 | 26873.01 | 0 | 19099.16 | 0
 | TEAMTEC AS | 0 | 0 | 0 | 7716.17 | 4288.219999999999
 | TTS GREECE LTD | 0 | 4827.51 | 3749.52 | 0 | 0
 | WARTSILA HELLAS AE | 0 | 0 | 19400.33 | 3427.95 | 0
 | DNV GL SE | -1062.24 | 0 | 0 | 6168.959999999999 | 27502.56