Forum Discussion

Copper Contributor

Mar 07, 2020

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...

excel

ExcelExciting
Mar 07, 2020
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
If you find the above solution resolved your query don't forget mark as Official Answer.

Aircraft.xlsx10 KB

ExcelExciting

MVP

Mar 07, 2020

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

If you find the above solution resolved your query don't forget mark as Official Answer.

BEN_FAWKES

Copper Contributor

Mar 07, 2020

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

ExcelExciting
MVP
Mar 07, 2020
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
If you find the above solution resolved your query don't forget mark as Official Answer.

Aircraft.xlsx10 KB
- BEN_FAWKES
  Copper Contributor
  Mar 10, 2020
  MANY THANKS. ALL SORTED. YOU ARE A STAR 😉ExcelExciting