Hi Tammy

It sounds as though the offending group of numbers that do not work are
formatted as Text in one case and Numeric in the other.
Do you have leading zeros with any of the numbers?
If so, then to enter them the cells containing them would have had to be
pre-formatted as Text, or the entry would have had to have a single quote
'0123 in front of the number to make it a text value.
--
Regards
Roger Govier

"tammyncook" wrote in message
...
Hello,
I have a spreadsheet which is basically a database. I want to create a
separate worksheet that will fill in with information from this database.
What I want to do is enter a number and have it fill in separate cells
with
info from the corresponding line from the source workbook.
I have it setup using Vlookup for each cell after I enter the number from
the spreadsheet. It seems to be working fine except for a certain group of
numbers. It doesn't always display the info from the source workbook. I
have
no idea why. I thought I had found some literature from Microsoft that
says
there is a known issue where it may not display if the source workbook is
not
open. But it only does this with a certain group of the numbers and not
with
the others. ??
Any suggestions?

__________ Information from ESET Smart Security, version of virus
signature database 4828 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4828 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com