Excel macro help? Can't get VLookup to work repeatably

Hello All,

I am working a small spreadsheet to help manage a part number database.  Our ERP system is really burly, but also not very convenient for pulling very basic standard parts information.  I'm running into an issue though where my macro throws errors every time I try to search for a part number using VLookup in VBA.  Can anyone provide any visibility as to what's going on?  For a comparison and to validate the approach, I put a duplicate form next to my macro form that pulls all of the same data using a worksheet VLookup function. 

Thanks in advance.

SolidworksGeneral