Hi!

Are your column headers the names of the months?

=VLOOKUP(D96,D95:R138,MATCH(A1,D1:R1,0),0)

Whe

A1 = drop down = some month
D1:R1 = column headers = Mar, Apr, May, Jun, etc

Biff

"Toni Bennett" <Toni wrote in message
...
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