Hello

I have three coloums of data which I want to put into a table format (below)
COL A as the rows, COL B as the column headers and COL C as the data

I have tried using a pivot table but the Data needs to be numeric, therefore
doesn't work. The same with sumproduct

I then tried using the following formula
=IF(AND(Data!$A:$A=Summary!$A3,Data!$B:$B=Summary! C$2),lookup,Data!$C:$C)
(with the data being on one sheet and the table being on a second sheet)

but it only seems to be doing the same as VLOOKUP and picking up the first
in COL C list using COL A as the reference.

I tried using ctrl-shift-enter but the formula just returned the result -
#NUM!


Does anybody have any ideas?
Thanks

COL A COL B COL C
29/50/100 Balance Sheet 05
29/50/200 Balance Sheet 05
32/20/000 Balance Sheet 09
34/10/000 Balance Sheet 10
29/50/100 Budget Managers MM
29/50/200 Budget Managers MM
32/20/000 Budget Managers ZZ
34/10/000 Budget Managers ZZ
29/50/100 Contact Care ZZ
29/50/200 Contact Care ZZ
32/20/000 Contact Care ZZ
34/10/000 Contact Care ZZ
29/50/100 Copy to Repairs N
29/50/200 Copy to Repairs N
32/20/000 Copy to Repairs N
34/10/000 Copy to Repairs N
29/50/100 Fixed Assets rp ZZ
29/50/200 Fixed Assets rp ZZ
32/20/000 Fixed Assets rp ZZ
34/10/000 Fixed Assets rp ZZ
29/50/100 General IE ZZ
29/50/200 General IE ZZ
32/20/000 General IE ZZ
34/10/000 General IE ZZ
29/50/100 Housing Summary ZZ
29/50/200 Housing Summary ZZ
32/20/000 Housing Summary ZZ
34/10/000 Housing Summary ZZ
29/50/100 Recharge ZZ
29/50/200 Recharge ZZ
32/20/000 Recharge ZZ
34/10/000 Recharge ZZ
34/10/000 VAT Details CN
29/50/100 VAT Details ZZ
29/50/200 VAT Details ZZ
32/20/000 VAT Details ZZ