for cell j9, use data validation with a list of Jan, Feb, Mar,

then use this formula
=VLOOKUP(1,INDIRECT($J$9&"!A7:B21"),2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jaytee" wrote in message
...
I want to set up 12 tabs, one for each month. Then I want to set up a
series
of Vlookups on a 13th page, that will grab info based on a Drop down
selection of months. So if I select "JUN" in the drop down, it will
VLOOKUP
info on the "JUN" tab. If I select "AUG", it will look in the "AUG" tab.
How
might this be done.