+ Reply to Thread
Results 1 to 2 of 2

Retirement Calculator Dashboard

Hybrid View

  1. #1
    Registered User
    Join Date
    04-23-2022
    Location
    MI
    MS-Off Ver
    365 for enterprise
    Posts
    1

    Retirement Calculator Dashboard

    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!
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,736

    Re: Retirement Calculator Dashboard

    Try

    =VLOOKUP(EDATE($I$2,$J$2*12),$A$2:$H$1000,8,0)

    I2="start" date

    J2=Years to retirement e,g 25 (converted to Months)
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel MiniSheet Calculator within a sheet / Flyout Calculator
    By Escavell in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-03-2020, 07:54 AM
  2. Replies: 1
    Last Post: 06-29-2020, 12:04 PM
  3. Dashboard help! Data from columns showing in the correct boxes on dashboard
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 35
    Last Post: 06-27-2019, 11:10 AM
  4. Trying to create a retirement calculator
    By Muzbo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2013, 11:53 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1