Vlookup and return values along a Row

Hi i touched on this in another thread ... but was told to make a new one so here goes
I will upload a test file to illustrate

I have monthly revenue figures for 2011 and 2012 held on a master file that is updated daily- Every so often i update the figures for each month on my personal spreadsheet using a simple vlookup, using this method i drag the formula across each Month "coloum" and down each row for account numbers individual and then adjust the reference cell at the end of the vlookup ... this is laborious.

I want a formula that will return the value for coloumn 2 for example but then automatically pick coloum 3 when i drag it to the adjacent cell

I apologise if this has been explained in a 5 yr olds language

Test File 2.xlsx

Oh btw sheet 2 replicates the master file and sheet 2 replicated my file

thanks for the input, My only problem with this formula is it requires me to know the exact cell reference and required the data is ordered as neatly as in my exapmle .. the reason i use a v lookup now is the account numbers can be anywhere in the reference file which is huge and contains thousands of clients and multiple coloums of data up to 221 coloumns

Brilliant I have been racking my brains for 4 months over this one !!!