Forum Discussion
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 next column to automatically fill in the type?
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
5 Replies
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
