Index match issue

[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 Country
-----------------------------------------------------------------------------------
2 CATEGORY Team 1 Team 2 Team 1 Team
-----------------------------------------------------------------------------------
3 Awards
4 Communication
5 Development
6 Training
7 Reporting

Thanks in advance for any help on this.

Regards,
Stringhaussen

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Dave Peterson]

You may want to look at using the =index(match()) instructions from Debra
Dalgleish's site:

http://contextures.com/xlFunctions03.html
and especially:
http://contextures.com/xlFunctions03.html#IndexMatch3