Lookup table

All,

This has probably been questioned before and I have done some searching and I can't quite find what I am after on the forum.

So I have the below table...

	1	2	3
1	547.88	730.5	1095.75
2	365.25	575.875	730.5
3	182.625	365.25	575.875
4	91.3125	91.3125	91.3125
5	30.4375	30.4375	30.4375

And I need to lookup a value based on Row 1 (Group) and Column 1 (Average Value) which are calculated elsewhere. Once I have the value I want to add this to another value (original date) to get a new value (NextDate)
I could write it as a load of if statements but this seemed like a waste of code

Is there an easy way out of this one?

Thanks in advance..

Bit more googling and this is the code I am trying...

Please Login or Register  to view this content.

Trevor

Please Login or Register  to view this content.

I am getting an error around the "$" sign...

R

Okay I have made a bit progress and I am now getting a 424 error...
So close and yet so far..

Please Login or Register  to view this content.