'Find the last entry of a year and get adjacent value
I would like a method to search through Column A and find the last entry of the year marked in K3 (2030), and display the corresponding Balance from Column H.
Problems I'm having:
- Making the Vlookup search for the year in the date column
- Finding the LAST entry for that year in the date column
Here is a link to the spreadsheet: https://docs.google.com/spreadsheets/d/13xhlfcV7KsRr3ObH5z1fxYUEMt8c6jssjlIozHk1MCI/edit?usp=sharing
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|