not sure what formula should i use for this basically i have columns a,b, c, d and e where in a i have company name and in b i have year, in c i need to fill the total assets of the company 1 year before the year in column b, in d i need to fill total assets at the year in column b, and in e i need to fill total assets a year after the year in column b

of course i have another worksheet which in column a list all the names of the company, in column b list the year, and in c total assets
the worksheet format is like this:
a b c
company A 2000 $400
company A 2001 $350
company A 2002 $500
company A 2003 $600
and so on with the next years, and the next companies

so in the end i want to have the worksheet like this:
a b c d e
company A 2001 $400 $350 $500

of course the year is not necessarily always 2001

suggestions ?
thank you !!