Hello. How could I create a formula that would look up based on month, category, and most importantly an indirect? I have attached a spreadsheet, the indirect is in K13 (and could be Quarter 1, Quarter 2, Quarter 3, Quarter 4) with matching data in "Sheet 2". Thanks
1 simple way to do this would be to give each qtr a range name, and then use that range name in K13, with this, copied down and across...
=VLOOKUP($A4,INDIRECT($K$13),COLUMN(),0)
Note, the qtr in K13 will need to be enteres with an underscore instead of a space...QUARTER_1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Another option without using range names....
=OFFSET(INDIRECT(ADDRESS(MATCH($K$13,Sheet2!$A:$A,0),1,,,"sheet2")),ROWS($A$1:$A1),COLUMNS($A$1:A$1))
Hey FDibbins, I tried the first option but it didn't work. It gives me an NA#. Could you attach the spreadsheet? Thanks. The numbers that are highlighted are actuals. I don't want to change those. I've added a replica below where I would like to pull the data into.
Last edited by amartino44; 12-06-2013 at 01:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks