AnsweredAssumed Answered

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

Question asked by Damon Frashure on Aug 26, 2016
Latest reply on Aug 29, 2016 by Damon Frashure

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.

Attachments

Outcomes