Required the desired result from some datas

I have a data in the following way:-

Year Series
2009 12190
2010 10210
2008 11180

Now,I want the result in the following format after putting the Input field:-

Year Input Series
2009 475 1219000475
2010 475 1021000475
2008 475 1118000475

My question is when I put the input data,the formula read the year from the above table and insert a 10 digit of Series that is my expected result.Please to be noted that whenever,I change the year,the formula read year and then 5 digits of series from the above table and picking the input field it should convert automatically into 10 digits of series.

Regards

Pradeep Kumar Gupta

Post a sample file... in reality it will be a case of:

=VLOOKUP(year,yearseriestable,2,0)&TEXT(Input,"00000")