Vlookup from bom

[JohanRoets]

Hi
I’m new to the forum; I need help with a Vlookup formula? My data workbook is very big so here is an example.
Sheet 1; StockCods
A B
StockCode Description
1 P900 Pine 114 x 900
2 P1200 Pine 114 x1200
3 P1500 Pine 114 x 1500
4 P1800 Pine 114 x 1800
5 BED001 BED DRWR
6 PED007 PED JAMBO
7 KIT009 KIT UNIT F4
Sheet 2; BOM
A B C
StocCode Component code Quantity
1 BED001 P900 5
2 BED001 P1200 7
3 BED001 P1800 3
4 PED007 P1500 6
5 PED007 P1800 2
6 KIT009 P1200 1
7 KIT009 P1500 8
8 KIT009 P1800 10
Sheet 3; Sales Summery
A B D E F G H
StocCode Description Quy P900 P1200 P1500 P1800
1 BED001 BED DRWR 5 25(P900) ? ? ?
2 PED007 PED JAMBO 10 60 (P1500)? ? ?
3 KIT009 KIT UNIT F4 7 7 (P1200) ? ? ?

This is my formula =SUM (VLOOKUP ([@[Stock Code]],BOM!$A$5:$C$7717,3,FALSE))*[@Quantity] in my big datasheet. (Sheet 3 E1 to E3) but it pick up the first one of the BED001, PED007, KIT009 in Colum C. In Sheet 3; I need a formula in E1 for P900, F1 for P1200, G1 for P500 and H1 for P1800. I do not mind if it gives me an A/N in E2

Hope someone can help me
Many Thanks
Johan

[JohanRoets]

Hi
Sorry for the mes I did my Question on Word and it seams lik it skrambel every thing i wil try agen.
Thanks
Johan