I have created a drop down list for month's of the year and selected March
which is Month 2 in our financial year but is located in column 3.

I have been able to create a VLOOKUP formula as follows =VLOOKUP('Money &
Budgets'!D96,'Money & Budgets'!$D$95:$R$138,3,FALSE) and it works just fine.

But, I can't work out how to do the following. I want to be able to select
April in the drop down box and have my VLOOKUP search the same data but get
the answer from column 4 not column 3. I have been at this for days and am
getting nowhere.

Please help if you can.

Thanks Toni