Get to single cell using multiple criterias on a range

[jbdevon]

Hello Everyone,
I need small help. I have a range where data is arranged in following way.

Country Category Product Jan07 .... through Feb 10 months.
Ireland Electronics TV some numbers for each month
Ireland Automotive Cars some numbers for each month
likewise about 1000 rows.. for about 6 countries..

What I want to do is actually transpose months in place of Country, so it becomes

Month Category Product ... List of Countries.
Jan 07 Electronics TV ... some numbers for country
....

Since there is only one row with possible combination values for each country, category, product for each month, there will be only one row with again similar combination for month, category, product... So I don't need to use SUM ( if (....) ), but I can't figure out how to use MATCH/INDEX/OFFSET to get to a single value based on say multiple criterias on a range..

so if I have a range full from A1 to Z1000, where A1 to Z1 is column headings and A2 to C999 are the combinations, values are in D2 to D999.
What I thought of is to use Index & Offset first to get to range for Country, then Category then product and that way find a one cell for each month.. But not working..

Can some one help me kick start please ?
Thanks,
JB

 

[hiker95]

jbdevon,

Welcome to the MrExcel board.

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php