Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula that grabs info from a specific tab
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula that grabs info from a specific tab
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula that grabs info from a specific tab
Nope, didn't quite follow that...
If the formula is : =JUN!A1, where do I insert an INDIRECT to allow the "JUN" to change to "OCT", for instance? =INDIRECT(B4!A1) where B4 is the drop down box of months, and A1 is the reference on the monthly sheet didn't work. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula that grabs info from a specific tab
Where j9 is your month in the drop down. Silly me. Since you said "lookup",
I thought you wanted VLOOKUP =INDIRECT($J$9&"!b7") -- Don Guillett Microsoft MVP Excel SalesAid Software "Jaytee" wrote in message ... Nope, didn't quite follow that... If the formula is : =JUN!A1, where do I insert an INDIRECT to allow the "JUN" to change to "OCT", for instance? =INDIRECT(B4!A1) where B4 is the drop down box of months, and A1 is the reference on the monthly sheet didn't work. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
A formula that grabs info from a specific tab
Hi,
From your message "will VLOOKUP info on the "JUN" tab". Based on this statement Don's answer addresses your question. =VLOOKUP(A1,INDIRECT(B1&"!A1:F100"),2,FALSE) If the drop down is in cell B1, and displays the sheet names, then this formula looks up the entry in cell A1 in the tab referenced in B1, lets say Jan, and looks at the range Jan!A1:F100 and returns the items in column 2 (here column B) if it finds the enter in A1 in the range A1:A100 on the Jan sheet. If this helps, please click the Yes button. cheers, Shane Devenshire "Jaytee" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
write formula that grabs data from last column | Excel Discussion (Misc queries) | |||
sum of 1 column if info in another = specific text | Excel Discussion (Misc queries) | |||
In excel, my mouse locksup and grabs everything when moving. why | Excel Discussion (Misc queries) | |||
connecting two Excel workbooks so one grabs info from antoher? | Excel Worksheet Functions | |||
how do you paste just specific info and not the hidden info? | Excel Discussion (Misc queries) |