How to find a row with latest date and its values
 

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

How to find a row with latest date and its values
 

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

....

MSSailor wrote:

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