error message during vlookup

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.

Deb Pingel wrote:
>
> 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
>
> --
> Deb Pingel
> ------------------------------------------------------------------------
> Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119
> View this thread: http://www.excelforum.com/showthread...hreadid=572346

--

Dave Peterson

that worked, I had 2 missing references, and we also discovered some empty spaces after the numbers we were tryiong to match. Mystery SOLVED!