Check very carefully the format of the data and that the source and
destination are the same.

In EXCEL 2007 you would do this through:-

Home / Font / click on arrow in lower right hand corner / Format Cells
should launch.

If the souce and destination cells are not consistent with each other this
may lead to problems.

Please hit Yes if my comments have helped.

Thanks.

"tammyncook" wrote:

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?