Formula to find latest/most current
I have two sheets. I need one to behave as a "log" (columns: Machine SN (Primary), Machine Hours, Machine Status (Dropdown List), Current Machine Location). This log will be populated by Forms. The second, separate sheet will be a "ledger" where each row will represent a different, individual machine (Machine SN) and the columns need to read the most current info from the columns in the log.
Is there a formula that I can have in the "Ledger" that will read the info in the columns in the "log" and return the latest/most current entries?
Thank you for your help!