How to find product weight with VLOOKUP

[xps15z]

I need help with establishing VLOOKUP to find the product weight. I continue to get a "#REF1" error in the column.

I should be using the SKU (B), and columns X and Y to determine product weight. But I am totally confused. I uploaded the excel to Google Docs so you can download it to excel. If someone can take a look and help that would be amazing.

https://docs.google.com/spreadsheets/d/1UP6wHOPMKTy6V_ZaaNzlB4w8MRFgZE9r8I608PAbOic/edit?usp=sharing

 

[gbutton]

Very odd, =VLOOKUP(B2,X:Y,2,0) works without error in my vlookup.

Could you try copying all of your data and using paste special to paste only the values in a new workbook? That might resolve any issues.

 

[xps15z]

Sorry, very silly mistake on my end. Too much excel today with formulas! But yes, that was correct. Thanks