Spreadsheet: 882262d1730540849-get-value-from-different-workbook-based-on-multiple-criteria-and-based-on-the-latest-date-get-value-from-this-file_current
Sheet: Match data from this file

 | Avd. | Maskin | Artikel_nr | Artikel besk. | [NAME] | [NAME] datum | Cykeltid | Antal fack
 |  | 1001 | 71110 |  |  | 2024-01-01 00:00:00 | 71 | 1 |  | The source file where the formula goes need the corresponding value in colum "H"
 |  | 1001 | 71110 |  |  | 2024-10-26 00:00:00 | 85 | 1 |  | Based on the matching criteras that is matches on
 |  | 1001 | 10202 |  |  | 2024-01-02 00:00:00 | 64.6 | 2 |  | column "C" and "D" then check for the latest date in column "G" and return the value in "H" from the matches and with the latest date
 |  | 1001 | 10199 |  |  | 2024-01-03 00:00:00 | 65 | 1
 |  | 1003 | 16106 |  |  | 2024-01-04 00:00:00 | 58 | 1
 |  | 1003 | 68117 |  |  | 2024-01-05 00:00:00 | 67.7 | 1
 |  | 1003 | 45136 |  |  | 2024-01-06 00:00:00 | 68.3 | 1
 |  | 1003 | 71114 |  |  | 2024-01-07 00:00:00 | 52 | 4
 |  | 1004 | 54146 |  |  | 2024-01-08 00:00:00 | 85 | 4
 |  | 1005 | 68107 |  |  | 2024-01-09 00:00:00 | 88 | 1
 |  | 1005 | 10405 |  |  | 2024-01-10 00:00:00 | 73.4 | 2
 |  | 1005 | 68118 |  |  | 2024-01-11 00:00:00 | 65.8 | 1
 |  | 1005 | 68103 |  |  | 2024-01-12 00:00:00 | 91 | 1
 |  | 1005 | 54163 |  |  | 2024-01-13 00:00:00 | 74 | 1
 |  | 1005 | 54161 |  |  | 2024-01-14 00:00:00 | 82.52 | 4
 |  | 1006 | 54146 |  |  | 2024-01-15 00:00:00 | 85 | 4
 |  | 1007 | 71112 |  |  | 2024-01-16 00:00:00 | 36 | 6
 |  | 1007 | 71113 |  |  | 2024-01-17 00:00:00 | 47.5 | 2
 |  | 1007 | 71108 |  |  | 2024-01-18 00:00:00 | 50 | 4
 |  | 1007 | 71107 |  |  | 2024-01-19 00:00:00 | 44.8 | 4
 |  | 1007 | 66001 |  |  | 2024-01-20 00:00:00 | 52 | 2
 |  | 1007 | 66005 |  |  | 2024-01-21 00:00:00 | 52 | 1
 |  | 1007 | 66006 |  |  | 2024-01-22 00:00:00 | 37 | 1
 |  | 1007 | 66008 |  |  | 2024-01-23 00:00:00 | 36.66 | 1
 |  | 1007 | 66010 |  |  | 2024-01-24 00:00:00 | 64 | 1
 |  | 1007 | 66007 |  |  | 2024-01-25 00:00:00 | 52 | 1
 |  | 1007 | 66004 |  |  | 2024-01-26 00:00:00 | 47 | 1
 |  | 1007 | 66009 |  |  | 2024-01-27 00:00:00 | 52 | 2
 |  | 1009 | 10301 |  |  | 2024-01-28 00:00:00 | 24.7 | 1
 |  | 1009 | 45121 |  |  | 2024-01-29 00:00:00 | 52 | 1
 |  | 1009 | 16104 |  |  | 2024-01-30 00:00:00 | 37.6 | 2
 |  | 1009 | 10158 |  |  | 2024-01-31 00:00:00 | 43 | 2
 |  | 1009 | 20106 |  |  | 2024-02-01 00:00:00 | 29 | 1
 |  | 1009 | 10159 |  |  | 2024-02-02 00:00:00 | 43 | 2
 |  | 1009 | 10163 |  |  | 2024-02-03 00:00:00 | 43 | 1
 |  | 1009 | 10203 |  |  | 2024-02-04 00:00:00 | 38.8 | 2
 |  | 1009 | 45122 |  |  | 2024-02-05 00:00:00 | 27.1 | 1
 |  | 1009 | 45123 |  |  | 2024-02-06 00:00:00 | 46.8 | 2
 |  | 1009 | 20103 |  |  | 2024-02-07 00:00:00 | 40.2 | 1
 |  | 1010 | 10138 |  |  | 2024-02-08 00:00:00 | 28 | 2
 |  | 1010 | 10142 |  |  | 2024-02-09 00:00:00 | 38 | 2
 |  | 1010 | 10145 |  |  | 2024-02-10 00:00:00 | 38 | 2
 |  | 1010 | 45128 |  |  | 2024-02-11 00:00:00 | 20 | 1
 |  | 1010 | 10201 |  |  | 2024-02-12 00:00:00 | 33 | 4
 |  | 1010 | 10187 |  |  | 2024-02-13 00:00:00 | 30 | 1
 |  | 1010 | 62101/2 |  |  | 2024-02-14 00:00:00 | 0.5 | 1
 |  | 1010 | 10207 |  |  | 2024-02-15 00:00:00 | 64 | 1
 |  | 1013 | 61100 |  |  | 2024-02-16 00:00:00 | 70 | 1
 |  | 1014 | 54156 |  |  | 2024-02-17 00:00:00 | 72 | 4
 |  | 1015 | 10208 |  |  | 2024-02-18 00:00:00 | 151 | 1
 |  | 1015 | 10209 |  |  | 2024-02-19 00:00:00 | 151 | 1
 |  | 1015 | 10407 |  |  | 2024-02-20 00:00:00 | 68 | 4
 |  | 1015 | 65101 |  |  | 2024-02-21 00:00:00 | 79.2 | 1
 |  | 1015 | 65104 |  |  | 2024-02-22 00:00:00 | 70 | 1
 |  | 1016 | 54158 |  |  | 2024-02-23 00:00:00 | 63 | 1
 |  | 1016 | 54159 |  |  | 2024-02-24 00:00:00 | 74.6 | 2
 |  | 1016 | 54162 |  |  | 2024-02-25 00:00:00 | 59 | 1
 |  | 1017 | 54156 |  |  | 2024-02-26 00:00:00 | 77.8 | 1
 |  | 1017 |  |  |  | 2024-02-27 00:00:00 | 77.8 | 1
 |  | 1018 | 54155 |  |  | 2024-02-28 00:00:00 | 70 | 2
 |  | 1019 | 54155 |  |  | 2024-02-29 00:00:00 | 67.7 | 2
 |  | 1020 | 54166 |  |  | 2024-03-01 00:00:00 | 55 | 1
 |  | 1020 | 54159 |  |  | 2024-03-02 00:00:00 | 74.6 | 2
 |  | 1022 | 71115 |  |  | 2024-03-03 00:00:00 | 65.3 | 1
 |  | 1022 | 71116 |  |  | 2024-03-04 00:00:00 | 69.5 | 1
 |  | 1022 | 10200 |  |  | 2024-03-05 00:00:00 | 77 | 1
 |  | 1022 | 71119 |  |  | 2024-03-06 00:00:00 | 69.5 | 1