Sum product?

[Jenawade]

I have a sheet with part numbers in column A, quantity in column B, site numbers in column C. I need some sort of look up to use on another sheet that looks at both the part number and the site, and provides the Quantity for that part number within that site.

Something like: Column D: =IF(QOH!A=643,VLOOKUP(A2,QOH!A:B,2,0),0), Column E: =IF(QOH!A=12,VLOOKUP(A2,QOH!A:B,2,0),0), Column F: =IF(QOH!A=53,VLOOKUP(A2,QOH!A:B,2,0),0). -- a sum product maybe?

Thanks in advance for any assistance!

 

[Jenawade]

Sorry, never mind, should have searched harder BEFORE posting instead of after. Am using http://www.mrexcel.com/forum/excel-questions/548220-vlookup-two-columns-get-value-third-column.html to do it.