I have 2 sheets . One that shows me a part number description and qty on open orders at I have through a pivot table . I have another sheet for my inventory that shows Part number description and on hand qty. I want to do a vlookup on the open orders to show me how many I have on hand to fill these orders. can't get the formula right. The sheet with open orders uses cells a2-C2 down to a48-c48 The qty on hand as columns a2-c2 down to a5055-c5055. Can anyone help.