Hey all, Thank you in advance for the help!
I'm building a job specific retirement calculator and I'm stuck on a dashboard function. I would the user to be able to enter the number of years until retirement and pull the amount from a table with the corresponding date. For example:
A6:A608 contains =EOMONTH(1/1/22,0)+1, listing the start of each month for 50 years. H6:H608 contains dollar amounts for those corresponding months. User enters '25' into a cell for years until retirement. I'd like the formula to pull the date 25 years from 1/1/22 (or whatever the start date may be) and return the corresponding H value.
I can't seem to get vlookup syntax to cooperate. any help is appreciated!
Bookmarks