Row and Column lookup and fill value

[Prascena]

Hi,

1st sheet of my excel:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]35582ac[/TD]
[TD]35582de[/TD]
[TD]38920aa[/TD]
[TD]38032f[/TD]
[/TR]
[TR]
[TD]332[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]122[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

2nd sheet of my excel:

[TABLE="width: 500"]
<tbody>[TR]
[TD]IR No[/TD]
[TD]Assembly No[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]04[/TD]
[TD]35582ac[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]122[/TD]
[TD]38920aa[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]122[/TD]
[TD]38852de[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]38032f[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]332[/TD]
[TD]35582ac[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]332[/TD]
[TD]38852de[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

Required Output:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]35582ac[/TD]
[TD]35582de[/TD]
[TD]38920aa[/TD]
[TD]38032f[/TD]
[/TR]
[TR]
[TD]332[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]122[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

Is it possible to automate this?

Please help with the formula.

Thank you in advance.

Regards,
Prasanna.A

 

[steve the fish]

Like this:

=SUMIFS(Sheet2!$C$1:$C$100,Sheet2!$A$1:$A$100,$A2,Sheet2!$B$1:$B$100,B$1)

You need to make sure your codes are identical though. 38852de is not 35582de