+ Reply to Thread
Results 1 to 4 of 4

Finding the year and month matching todays date and returning a value from adjacent cells

Hybrid View

  1. #1
    Registered User
    Join Date
    08-07-2014
    Location
    UK
    MS-Off Ver
    2003
    Posts
    2

    Finding the year and month matching todays date and returning a value from adjacent cells

    Hi,

    first post so apologies if this isn't the right place.

    Having trouble finding the solution to this specific problem.

    I have a spread sheet used for budgeting a loan, which calculates the compound interest and amounts paid off interest and capital of this specific loan.

    Each row contains information for that months payment and the last column displays the outstanding loan sum after various capital repayments and interest calculations. The sheet then goes on down showing each month until the loan is due to be paid off. I use this to manage overpayments and predict how various lump sum or regular overpayments will reduce the term of the loan by how much and how much interest I would save if I made said overpayment.

    I want to put a cell at the top of the spread sheet which shows how much is outstanding on the loan, live, for todays date / month.

    Each row has a year column and a month column but nothing more.

    I want the sheet to recognise todays month and year, then find the current year from the list of years in column B, the current month from column C and return the value in that row from column J to a cell at the top of the page (cell J2) that corresponds to the match of this year and month.

    Obviously the sheet has 12 duplications of each year (as the year is present in the year column for each of the 12 months) and there are multiples of every month for however long the loan is predicted to last (ie; if the loan is for 10 years, I will have listed in the month column each month 10 times over next to each year 2014, 2015, 2016 etc etc...)

    I hope I have been specific enough and I hope you can help me.

    Thanks.
    Steve.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Finding the year and month matching todays date and returning a value from adjacent ce

    Hi there... and welcome to the Excel Forum.

    Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    08-07-2014
    Location
    UK
    MS-Off Ver
    2003
    Posts
    2

    Re: Finding the year and month matching todays date and returning a value from adjacent ce

    Hi,

    The uploaded doesn't appear to be working??? Is there another way?

    I get a window allowing me to pick the file I want to upload, but then it just sits there for ages with the pin wheel going round and nothing happening. File isn't big only 29K.

    Thanks.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Finding the year and month matching todays date and returning a value from adjacent ce

    It does that sometimes; a bit of a pain in the @ss! Start from scratch & see what happens...

+ 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. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  2. Finding matching cells then returning data of another cell
    By GenericPat in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-19-2012, 03:36 PM
  3. Replies: 1
    Last Post: 08-13-2012, 11:18 AM
  4. Replies: 1
    Last Post: 06-09-2006, 12:45 PM
  5. Finding the date on the 'nth' Monday in this Month in this Year
    By agarwaldvk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2006, 05:55 PM

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