VLOOKUP combination

[nick2price]

Hi, having a bit of trouble figuring something out. I have a simple table like the following

Please Login or Register  to view this content.

Lets say that is in a sheet called Cost. I then have another sheet called Increase. This sheet has the following structure.

Please Login or Register  to view this content.

Now the Year in the Cost sheet is dynamic, I do not really know what the first year will be (not sure if this matters). Whatever the case, the first year in this table will always have a value.

Here is the part I am stuck on. The second year in the table should be the previous years cost plus the Increase value according to the Increase sheet for that Year. So in the above case, the second year is 2016. Therefor the cost should be
$2000 + 2.45% = $2049

The 2.45% comes from the Increase sheet for the Year 2016.

How can I replicate this in a formula?

Thanks

[AlKey]

Maybe like this

in C2 and copy down

=IFERROR(B$2*(1+VLOOKUP(A2+1,$E$2:$F$7,2,0)),"")

Row\Col	A	B	C	D	E	F
1	Year	Cost			Year	%
2	2015	2000	$ 2,049.00		2012	1.00%
3	2016		$ 2,055.80		2013	1.34%
4	2017				2014	1.87%
5					2015	2.12%
6					2016	2.45%
7					2017	2.79%

[TMS]

B3 would be =B2*(100% + VLOOKUP(A3, increase table, 2, FALSE))

Regards, TMS