Tacitus1991
New Member
- Joined
- Jul 6, 2018
- Messages
- 3
Good Day,
I am a commercial pilot and I am developing my own flight logbook sheet (I know there are 1000'ds out there, but I want my own.)
I have it fine tuned, I just need some help with what I think is a VLOOKUP function, but I am not sure.
So what I have done is I have 2 Tabs, Tab 1 is the actual Logbook and Tab 2 is a summary page that generates a summary as you populate the logbook.
I need to get a formula where the summary looks at a specific column, and looks for the last time I flew a specific type of aircraft, then looks at the date next to that flight and returns that value. I am bamboozled. I have a link to the logbook (You are free to use it if you wish):
https://drive.google.com/file/d/1SGOVHWbSos-7TN56eASooChkFSc9WHZn/view?usp=sharing
Please help.
I am a commercial pilot and I am developing my own flight logbook sheet (I know there are 1000'ds out there, but I want my own.)
I have it fine tuned, I just need some help with what I think is a VLOOKUP function, but I am not sure.
So what I have done is I have 2 Tabs, Tab 1 is the actual Logbook and Tab 2 is a summary page that generates a summary as you populate the logbook.
I need to get a formula where the summary looks at a specific column, and looks for the last time I flew a specific type of aircraft, then looks at the date next to that flight and returns that value. I am bamboozled. I have a link to the logbook (You are free to use it if you wish):
https://drive.google.com/file/d/1SGOVHWbSos-7TN56eASooChkFSc9WHZn/view?usp=sharing
Please help.