Index & Match Question

[Stringhaussen]

Hi,

Getting a little confused on how to do this one. I have a list of raw data,
in column A I have a list of categories, in B a list of countries, C has a
list of teams and D has a list of values that I need pulling across on to
another spreadsheet like the one below. I'm pretty sure I have to do an Index
Match, but I'm not sure how with 3 sets of criteria to match.

_____A______________B_________ C________ D__________ E______
1 Country 1 Country 1 Country 2 Country2
-----------------------------------------------------------------------------------
2 CATEGORY Team 1 Team 2 Team 1 Team 2
-----------------------------------------------------------------------------------
3 Awards
4 Communication
5 Development
6 Training
7 Reporting

Thanks in advance for any help on this.

Regards,
Stringhaussen

 

[Eduardo]

Hi,
look into Debra web she has excellent examples

http://www.contextures.com/xlFunctions03.html

if this helps please click yes thank you