I have a vlookup that is searching for product numbers in a separate workbook that has a list of product numbers and their shipping box dimensions. MOST of the product numbers were found by the vlookup, but for some reason it skipped over many, even after I checked to make sure they were in fact in the other book. Maybe it's a formatting issue? In the spreadsheet "shipping example" I have a vlookup in B92 that returns NA. I feel like I'm doing something wrong, but I can't quite figure out what it is. I'm sure it's something easy, but it's driving me up the walls! If anyone can check it out and help me figure out what's going on, it would be much appreciated.
=VLOOKUP(B92,[pricingandboxes.xlsx]Sheet1!$A:$B,2,FALSE) is what's in B92 on shipping example.
pricingandboxes.xlsx
shipping example.xlsx
Let me know if you need more info.
Again, thank you!
Bookmarks