Since you're working with numbers, my bet is that one is really text
masquerading as numbers. So =vlookup() won't find a match.
Debra Dalgleish has notes about =vlookup() he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble
On the other hand, you may want to try to automate the process...
http://contextures.com/xlForm03.html
http://contextures.com/xlForm02.html
(also from Deb's site.)
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?
--
Dave Peterson