LOOKUP and IF FUNCTION

[midgetmogalle]

I am trying to create an inventory spreadsheet with two sheets in one workbook. The first sheet is where I want all info to appear. On this first sheet is a column (G) called VENDOR INVENTORY. I would like this column to be autofilled from the second sheet column (D) called INVENTORY ON HAND. This is the formula I thought would work: =VLOOKUP(InventoryOnHand!$A2,InventoryOnHand!$A$2: $D$49,4,FALSE). However I don't get the correct information for each line item.

I have attached images so you can all see what I am talking about. I am not sure if I should be using an "IF" in addition to my "LOOKUP" or if I should be using "VLOOKUP" which I also tried and got incorrect results.

Please help ASAP!