I may have already posted this but I couldn't find my question!! Anyway, I
have created a drop down list of months in order to capture monthly
accounting data. March is the 2nd month in my accounting year and is located
in column 2 of my table.

I then created the following VLOOKUP formula which gets the data I want.

=VLOOKUP('Money & Budgets'!D96,'Money & Budgets'!$D$95:$R$138,3,FALSE)

Question. How should I write the formula so that if I change the drop down
list to April the VLOOKUP formula automatically changes to look in column 4
for the data instead of column 3. May should select column 5, etc.

I have been at this for hours, days and nights and just can't get my head
around it.

Please help. Thanks Toni