Offset function for cashflows in different years

[neodjandre]

Hi,

I have got three period like this


Period: 2010 2015 2018
Cash: 100 200 300

I would like to use a function (i am thinking offset will do the work) to put these cashflows on a timeline i.e. 2010,2011,2012 etc...

The three periods described above will be changeable, so the cashflows will adjust accordingly...

can anyone help with this?

cheers
andy

 

[Andrew Fergus]

Hi

The answer provided by Tushar should work. The formula provided :
=HLOOKUP(F2,$B$2:$D$3,2,TRUE)
is designed to be copied across to column T. If it isn't working I recommend you check you have the $ symbols in the correct places, or post back with the formula you used.

Andrew

 

[neodjandre]

right.. i apologise but i had messed up the $ symbols.. thanks to both of you