I have data on sheet1 & sheet2 and I want to apply formula on sheet3 to link
the Qty. while I have try with Vlookup and Sumif but got success only as
Vlookup(sheet1€¦..)+Vlookup(sheet2€¦..)

Sheet1
Code Imported Material Qty
101 A 5
300 B 10
400 C 7

Sheet2
Code Local Material Qty
102 X 3
104 Y 8
203 Z 2

Sheet3
Code Material used Qty
101 A 5
102 X 3
104 Y 8
203 Z 2
300 B 10
400 C 7

Thanks
Zafar