V
vlook fomula
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
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