Results 1 to 2 of 2

Retirement Calculator Dashboard

Threaded View

FIby40 Retirement Calculator... 04-23-2022, 04:17 AM
JohnTopley Re: Retirement Calculator... 04-23-2022, 05:17 AM
  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

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