Data is being retrieved from a separate source. The workbook with the
destination cells asks to update every time it is opened. No macros though.

"Dave Peterson" wrote:

If your entries are digits, then it's not enough to just change the format of
the cells. You'll want to make the values numeric, too.

I like to find an empty cell
Edit|copy
Select the offending cells
Edit|paste special|add

This will coerce the "text numbers" to "number numbers".

You may need to do this to both ranges--the values you're matching and the
values in the first column of the vlookup range.

But that doesn't explain why your values (and formatting(?)) change when you
close and reopen the workbook.

Is the data static or is it being retrieved from some other source (maybe
refreshed when the workbook opens???)?

If you open the workbook with macros disabled, does the problem go away?



tammyncook wrote:

Okay. So I've checked to see if the destination & source are formatted the
same. They were not. So I fixed that.
BUT... here's the part I don't understand then.
They all work to start with. I enter the number I want it to pull the
dependant information for. All the info pulls in. I save it and close it,
then some time later, I will be notified that it's not pulling it in. Sure
enough I go look and all my values are at #N/A as if I never had entered the
number to begin with.
Will it behave this way due to the formatting??
Thanks,

--

Dave Peterson
.