Nope.

Actually there was a small mistake in my though process (should be product of growth rates so 1+..).

I reviewed the problem yesterday and realized that I couldn't see the forest for all the trees- I thought I would need a very complex solution when I can make due with my current dataset and just use a HLookup. I suppose that sometimes you can be too close to the problem!

Thanks anyway for your time,

M