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 sheet has 2 columns: Flight time and Aircraft registration (like plate number for cars)

- Aircraft sheet has 2 columns: Registration and Aircraft model

(the actual workbook is much more complex than this, I am keeping it simple here)

In the flight logging sheet every row represent a flight, and for each row the registration can change.

I am trying to sum all the flight hours done on one particular model of aircraft (multiple registrations can correspond to the same model).

So for each row I need to lookup the registration to know which model it is and compare it to the model of aircraft I am looking for.

I have an array formula where the argument / lookup value is an array (because the value to lookup changes for every row) but it is not working I have the N/A error message.

Any help will be appreciated.

Thank you