» Retrieving a value from a reference grid according to index values
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem:Range A1:D5 contains numbers, arrayed in a reference grid specified in row 1 (columns) and column A (rows).
How could we find the value in Range A8:D10 matching each pair of index values (column and row) in Range A7:D5?
Solution:
Use the INDEX and MATCH functions, as follows:
=INDEX($A$1:$D$5,MATCH(B8,$A$1:$A$5),MATCH(A8,$A$1:$D$1))

Book Store:
Recommended Books:
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Learn MS Excel 2002 VBA/XML Programming
- The Fall of Advertising and the Rise of PR
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
No comments have been submitted.

