Average and vlookup help needed

[Des1801]

Hi all,

I have a problem where I am trying to combine a VLOOKUP, and AVERAGE and an addition all together. For example, I have data that looks like

Column A / Column B
Jan-13 / 15
Feb-13 / 12
Mar-13 / 7
Apr-13 / 22
May-13 / 7
Jun-13 / 11
July-13 / 19

In another worksheet I want to have a formula that will pickup 2 months contained in 2 different cells (e.g. Feb-13 and May-13 in cells A1 and A2) and lookup the number next to that month, and all months in between and provide me with the average of those numbers. In the above example I would want to return the average of 12, 7, 22, and 7 just by referring to the 2 cells containing the months. These cells containing the months will also change depending on other data entered elsewhere in the sheet.

Grateful for any help provided. Cheers

[sktneer]

Please find the attached sheet to see if this helps.