Required Formula

[amkumar]

hi,

i have some data in below table format

[TABLE="class: grid, width: 130"]
<tbody>[TR]
[TD]Unique ID[/TD]
[TD]Year[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]5819M2[/TD]
[TD]1996[/TD]
[TD]4568[/TD]
[/TR]
[TR]
[TD]5819M2[/TD]
[TD]1994[/TD]
[TD]3694[/TD]
[/TR]
[TR]
[TD]5678Z9[/TD]
[TD]1995[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]5678Z9[/TD]
[TD]1996[/TD]
[TD]7456[/TD]
[/TR]
[TR]
[TD]9313A5[/TD]
[TD]1996[/TD]
[TD]2460[/TD]
[/TR]
[TR]
[TD]4556K2[/TD]
[TD]1994[/TD]
[TD]465[/TD]
[/TR]
[TR]
[TD]4556K2[/TD]
[TD]1995[/TD]
[TD]5290[/TD]
[/TR]
</tbody>[/TABLE]

i want the same data in below table format with the use of formula.[TABLE="class: grid, width: 120"]
<tbody>[TR]
[TD]Unique ID[/TD]
[TD]1994[/TD]
[TD]1995[/TD]
[TD]1996[/TD]
[/TR]
[TR]
[TD]5819M2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5678Z9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9313A5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4556K2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Please help me in this....Thanks in advance....!!!!

 

[Legacy 143009]

It's an array formula so you have to Ctrl+Shift+Enter after paste. Have a nice day

=INDEX(Table1!$C$2:$C$8,MATCH(B$1&$A2,Table1!$B$2:$B$8&Table1!$A$2:$A$8,0))