VLOOKUP(), INDEX(), OFFSET() and MATCH() Question

**Paddon** · 11-03-2011, 12:29 PM

Hello All,

I am a little confused about the proper use of VLOOKUP(), INDEX(), OFFSET() and MATCH() functions and cannot get a rather simple task to work property. I have, on WorkSheet2 an amortization schedule, which has the following columns:

[Date] [Payment] [Interest] [Principle] [NewBalance]

The array containing the amortization schedule is A2:E50 on WorkSheet2.

On WorkSheet1 I have a cell, let's call it A1, that contains an beginning date. I would like to, in a different cell, sum the [Interest] cells corresponding with the beginning date down 12 dates (essentially summing the 12 interest payments commencing at the Beginning Date).

Any help would be greatly appreciated.

Please Login or Register  to view this content.

**MarvinP** · 11-03-2011, 12:47 PM

Hi Paddon,

See if this works for you.

Please Login or Register  to view this content.

see the attached to change the Input date value.

**Paddon** · 11-03-2011, 01:15 PM

Hi Marvin,

Your example worked perfectly. I discovered, in the process of trying to implement it, that having spaces in my actual worksheet name was a bad idea.

I was also able to pinpoint how I was incorrectly using MATCH() so thank you very much for that. In the future I will be more armed to deal with this sort of problem.

Cheers
Paddon