error message during vlookup

  • Thread starter Thread starter Deb Pingel
  • Start date Start date
D

Deb Pingel

While trying to do a Vlookup between 2 spreadsheets, I get an error
message that says
Microsoft Visual Basic
Can't find project ot library

Then when you click on OK, you are taken to a screen titles
References-VBA project.

The 2 spreadsheets are on the same drive and in the same folder. Any
ideals?

Thanks
 
Select each workbook's project (inside that VBE)
Tools|References
look for a reference marked MISSING (with a check mark next to it).

If you have that situation, uncheck that reference and save that workbook.
 
that worked, I had 2 missing references, and we also discovered some
empty spaces after the numbers we were tryiong to match. Mystery
SOLVED!
 
Back
Top