View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default A formula that grabs info from a specific tab

Read in Help about the INDIRECT function and then return if more is needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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.