In the attached workbook, the following formula appears in column B of the "dropdown" tab. I want to basically do a two criteria lookup, using the values in column A and the value of cell B1, which is a dropdown based on a dynamic range consisting of the company names on the Discounts tab.(starting with cell E1, extending rightward) To make this easier for testing purposes, I'm curretly using cell E1 instead of B1, which is just text.
It seems like this ought to work, but somehow it doesn't:
=OFFSET(Discounts!$B$1,(MATCH($E$1,Discounts!$C$1:$AA$1,0)),(MATCH(A5,Discounts!$B$2:$B$200,0)),1,1)
Last edited by jrussell; 08-07-2009 at 12:41 PM.
See attached.
Two example methods are used in the WB, each depending on named ranges.
=VLOOKUP(A5,Data.Table,MATCH($B$1,Data.Header,0),FALSE)
=-INDEX(Data.Table,MATCH(A5,AA_Codes,0),MATCH($B$1,Data.Header,0))
Note: The named range Data.Header kept getting corrupted for some reason. You may have to fix this if you have problems.
Hey, not one but two ways to do it. These both look like they should work, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks