How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel (214142)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
- Microsoft Excel 2004 for Mac
- Microsoft Excel X for Mac
- Microsoft Excel 2001 for Mac
This article was previously published under Q214142
For a Microsoft Excel 98 and earlier version of this article, see 59482.
SUMMARY This article offers several examples that use the INDEX and
MATCH worksheet functions in Microsoft Excel to find a value based upon
multiple criteria. REFERENCES
For more information about using lookup functions, click Microsoft Excel Help on the
Help menu, type about looking up values in
lists in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Major | Last Reviewed: | 5/5/2005 |
---|
Keywords: | kbQuery kbfunctions kbhowto KB214142 |
---|
|