How to do this using Excel code: List of values to table

[sasori]

Sorry for the totally undescriptive title. I'm having a hard time trying to describe it specifically using a decent title. Please treat me as a complete newbie, I have no idea what I'm doing except when using average formulas (lol).

I need to find a way on how to convert a list into a table. Given a set list of values a and b, I need to arrange them into a table.

The xlsx file is here.

 

[FormR]

Hi, welcome to MrExcel!

For future questions you may want to take a look here for ways to post your example data directly in the thread - you will get many more people taking a look that way:

http://www.mrexcel.com/forum/about-board/508133-attachments.html

Here is one option though, the formula in J7 can be copied down and across.

Excel 2013
	H	I	J	K	L	M	N
5			b
6			1	2	3	4	5
7	a	1	16	17	16	13	15
8		2	10	16	16	14	10
9		3	13	17	10	20	10
10		4	13	19	14	17	13
11		5	13	19	14	17	13
Sheet1

Cell Formulas
Range	Formula
J7	=INDEX($C$2:$C$26,MATCH(1,INDEX(($A$2:$A$26=$I7)*($B$2:$B$26=J$6),0),0))

Excel 2013
	A	B	C
1	a	b	P
2	2	5	10
3	3	5	10
4	3	3	10
5	2	1	10
6	4	5	13
7	5	5	13
8	1	4	13
9	3	1	13
10	4	1	13
11	5	1	13
12	2	4	14
13	4	3	14
14	5	3	14
15	1	5	15
16	1	3	16
17	2	3	16
18	2	2	16
19	1	1	16
20	4	4	17
21	5	4	17
22	1	2	17
23	3	2	17
24	4	2	19
25	5	2	19
26	3	4	20
Sheet1