How to find a row with latest date and its values

[MSSailor]

Have an basic info in "sheet A" with columns named like below, with hundreds
of rows with data:
Date,Flightnr, Aircraft, Dep.Airport, Arr.Airport, Flighttime etc etc

In "sheet B" I have a form that I want to present the latest flight

The last flight (most previous) was:
Date, Flight, Aircraft, Dep.Airport, Arr.Airport, Flighttime

 

[Dave Peterson]

If there are no gaps in the date column and the last flight is the bottommost
entry, you could use:

To return the last date:
=INDEX(Sheet1!A:A,COUNTA(Sheet1!A:A))

To return the last Flight:
=INDEX(Sheet1!B:B,COUNTA(Sheet1!A:A))

....