create X,Y axis grid from Columns in another spreadsheet?

[concretegoat]

In spreadsheet A I have two columns (A & B) that contain descriptive label/identifier text and then 1 column (C) that is an associated numerical value based on the non-mathematical correlation between the data from columns A and B.

---A B C
1 Qa Za 34
2 Qb Zb 19
3 Qc Zc 21
4 Qd Zd 11


I have a second spreadsheet (spreadsheet blue) that has the data from spreadsheet red's columns A and B organized with column A running horizontally across the top (x-axis) and column B running vertically down the left (y-axis)

----Qa Qb Qc Qd
Za
Zb
Zc
Zd

How can I program Excel to populate the grid created in spreadsheet B with the corresponding spreadsheet red column C data at the intersection of corresponding labels (Qa-Za, Qb-Zb, etc...) to give the following result?

----Qa Qb Qc Qd
Za 34------------
Zb ----19--------
Zc --------21----
Zd ------------11

[popipipo]

Please Login or Register  to view this content.

Try this array formula (<CTRL><SHIFT><ENTER>)