View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tammyncook tammyncook is offline
external usenet poster
 
Posts: 4
Default Is Vlookup the correct way to do this?

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,