Hello,
I am trying to construct a formula without using any scripts and hoping someone can help me out. I have attached a sample workbook with the problem.
I would like a formula on a separate sheet ('Formula') which will consider the following.
If Aircraft!E:E is "Turbo-Propeller" Then use the Aircraft!A:A values to find all matching registrations, in this case C-XXXX, C-YYYY and C-ZZZZ are all Turbo-Propeller.
Using the determined registrations, Lookup if Logbook!C:C matches any of those registrations, to sum the associated row Logbook!Q:Q.
There will be multiple entries for each registration (i.e.: C-XXXX) and I would like all registrations to add up for a total value.
The end result will be a list of all aircraft which are considered "Turbo-Propeller" and will have the values added for each column separately.
EDIT: I cannot edit the title anymore, but I do not necessarily need the lookup term used, as long as the formula works I am happy (I just took a guess that it would be used :P)
Thanks!
Problem.xlsx
Bookmarks