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.

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.