How can I create matrices of data in Excel?

Question

I want to create a 4*4 matrix in excel 2007 by taking three or more columns or conditions for example

Column index    Row index   Name
1              2             x
2              3             y
3              4             z
4              1             p

this is how data looks and i want it for 1*1 cell as p and 1*2 cell as x and so on. and I want out put as follows

matrix  1   2   3   4
1       p   x   y   z
2       p   x   y   z
3       p   x   y   z
4       p   x   y   z

and I have very huge data like this some times the matrix size goes up to 60*60 also.

Answer 1

I think you are wanting a multi-condition lookup. Here is a great example: http://chandoo.org/wp/2010/11/02/multi-condition-lookup/

Following the techniques in that link, you can do something like this:

Set up 3 named ranges covering your data. Note that the formula in J9 is an array formula, entered with CONTROL+SHIFT+ENTER. The nice thing about that formula is once you enter it as an array formula for just one cell, you can then drag it over and down as far as you need.

Also: the "IFERROR" part puts in blanks (instead of #N/A or #VALUE errors) if an error is encountered in the INDEX+MATCH part.