Help with Vlookup to Cross Ref Items and Prices

I need help with VLookup. In a worksheet named products I have a column of item numbers. I also have equivalent competitive item numbers. In the final XRF worksheet I'm trying to use VLOOKUP to make the cross reference and return the competitive price in its respective column in the XRF worksheet.
So in the XRF worksheet I'm looking for the same item number in the products worksheet. If equal I want the Column B in XRF to be the item's OEM number.

then I'd like the subsequent columns to lookup their cross reference number and return the price in that column.

=IF(ISNA(VLOOKUP($A$2:$A$47,products!$A$2:$A$655,1,TRUE))," ",VLOOKUP($A$2:$A$654,products!$A$2:$A$655,"2"))

I've attached the file. Hope someone can help. Thanks