|  

» Retrieving a value from a reference grid according to index values

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))
Screenshot // Retrieving a value from a reference grid according to index values
Retrieving  a value from a reference grid according to index values
Rate This Tip
12 34 5
Rating: 4.13     Views: 16580
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments