Forum Discussion
Solved
Pilot Logbook
Aircraft Logbook Column has column of aircraft Registrations G-TUIA to G-TUIJ. Types TUIA to TUII are type 787-8 and TUIJ to TUIN are type 787-9. When I type in the registration, how do i get the ne...
HI BEN_FAWKES
Make the master table where you have aircraft registration at one place, as per below image
I'm also attaching the excel for your easy reference
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
HI BEN_FAWKES
you can use VLOOKUP or XLOOKUP to grab that information if it is another table.
a small sample of your data with your desired output will help to advise you the correct solution
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
| 01/03/2020 | G-TUIA | B787-8 |
| 28/02/2020 | G-TUIF | B787-8 |
| 22/02/2020 | G-TUIC | B787-8 |
| 19/02/2020 | G-TUII | B787-8 |
| 15/02/2020 | G-TUIH | B787-8 |
| 12/02/2020 | G-TUIB | B787-8 |
| 05/02/2020 | G-TUIJ | B787-9 |
| 03/02/2020 | G-TUID | B787-8 |
| 27/01/2020 | G-TUIC | B787-8 |
| 20/01/2020 | G-TUIL | B787-9 |
| 05/01/2020 | G-TUID | B787-8 |
| 03/01/2020 | G-TUIF | B787-8 |
| 28/12/2019 | G-TUIE | B787-8 |
| 25/12/2019 | G-TUIC | B787-8 |
| 19/12/2019 | G-TUIM | B787-9 |
HI BEN_FAWKES
Make the master table where you have aircraft registration at one place, as per below image
I'm also attaching the excel for your easy reference
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
MANY THANKS. ALL SORTED. YOU ARE A STAR 😉ExcelExciting