I'm currently working on a Ship Ticket template that should populate in
certain fields of the form the latest text information found in a worksheet.
This would allow me print a Ship Ticket for my latest entry in that column.

I was able to use the following formula from previous posts, which helped me
grab the latest number value in that column:

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A,A2))

However, for fields containing names and dates, I would like to find a
formula that would pull those into the specific fields in my template.

In advance, many thanks for your help!!!

Mag