Lookup / Index Match where the lookup value is an array

Hello everyone,   I am trying to make an array formula where the value to look up changes for every row.   My workbook has 2 sheets: flight logging sheet and aircraft sheet: - Flight logging she...