Hi,
Can't figure out how to find the most recent entry that matches my criteria.
I have attached an example spreadsheet where the data table is in blue. The second table is the one I am creating, with everything in white already placed. What I am looking for is a formula to find the information in the green cells. That is, I want to search the data table for the matching employee number and have it display the leave balance that corresponds with the MOST RECENT date (column C). These dates are not sorted.
Thanks in advance for any assistance!!
Bookmarks