I have a workbook with several worksheets, based on what month is located in cell A1, I want to vlookup certain items from that months worksheet. So if Jan is in cell A1, then I want the formula to look at sheet "Jan", if Feb is in cell A1, then I want the formulat to look at sheet "Feb"
See the attachment...
Test Lookup different page values.xlsx
thanks in advance1
Last edited by 00Able; 02-04-2012 at 09:54 PM.
Providing Problems for Your Solutions
STARS are my Punching Bag, You will be rewarded.
In the rare event that I may help you, feel free to make me see STARS
As your sheets all follow the same structure, you can do it with a link using INDIRECT to select the sheet name. Put this in B2 of the M1 sheet:
=INDIRECT("'"&A$1&"'!d"&ROW(B3))
Then copy down to B7.
Hope this helps.
Pete
Thank You so much...took me a few minutes to get it to work for my specific needs, but I understand the formula now. I have been looking for the answer all day! Thanks!
Providing Problems for Your Solutions
STARS are my Punching Bag, You will be rewarded.
In the rare event that I may help you, feel free to make me see STARS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks