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

When I changed your formula in the XRF worksheet in Cell B2 to this

Please Login or Register  to view this content.

it returns the OEM number from the products worksheet. I couldn't really follow the rest of what you wanted but I hope this puts you in the right direction.

Look at the XRF worksheet. I'd like the value of cell C19 to be 786.26, which comes from the RDUCANE worksheet cell C115. What do I change the formula to read the products worksheet and the RDUCANE worksheet and write the value of that cell in RDUCANE worksheet to the XRF worksheet. I've attached the updated worksheet.

Your RDucan and WDucan spreadsheets are the same data. Is this a mistake? Not sure I can help you any further unless this is corrected.

Originally Posted by nander

Look at the XRF worksheet. I'd like the value of cell C19 to be 786.26, which comes from the RDUCANE worksheet cell C115. What do I change the formula to read the products worksheet and the RDUCANE worksheet and write the value of that cell in RDUCANE worksheet to the XRF worksheet. I've attached the updated worksheet.

The RDUCANE & WDUCANE will differ by the price in the price column. However I removed the DUC. prefix from the items in the RDUCANE worksheet.

I've uploaded the new version of the spreadsheet.