S
StargateFan
I found this video yesterday thanks to googling this ng:
http://www.datapigtechnologies.com/flashfiles/vlookup.html
Since it went into VLOOKUP step-by-step, I could finally set up a
spreadsheet with it. It was excellent for me.
But I ran into a bit of difficulty. He goes into setting up the
"unique key" fields in both target/source sheet (forgive terminology
errors as my mistakes, if I make any) as text. I've run into that
problem before so made infinite amount of sense to me. Product code,
in my case, is often mixed letters/numbers. So I followed his
instructions to the letter.
For the most part, it works and works perfectly. But about 4 out of
the 15-20 entries I made pulled the wrong. Is there a way to finetune
the accuracy? Yes, was able to get the right data eventually by
fiddling with cell format and switching from text to general to number
and back to text until the correct data popped in but I can't keep
doing it that way for the problem ones. One day I won't recognize
that the information is incorrect. I have so few entries at this time
that it was easy to pick up the mistake yesterday.
The VLOOKUP formula is a simple one:
=VLOOKUP($D2,GrandToy2008,2)
Hoping that there's just something simple I'm missing to increase
accuracy. I seem to remember seeing something that would tell Excel
that only 1 item was possible for each entry since sometimes one would
need to have several entries per product ID, i.e., when something like
"desk" is used to cover the various types of desks there might be. In
this case, only 1 item per product ID. Hopefully it's something that
simple to fix the problem. I haven't been able to find that message
again. I'm sure the reference was in one of the ones that came up in
google yesterday.
Thanks!
D
http://www.datapigtechnologies.com/flashfiles/vlookup.html
Since it went into VLOOKUP step-by-step, I could finally set up a
spreadsheet with it. It was excellent for me.
But I ran into a bit of difficulty. He goes into setting up the
"unique key" fields in both target/source sheet (forgive terminology
errors as my mistakes, if I make any) as text. I've run into that
problem before so made infinite amount of sense to me. Product code,
in my case, is often mixed letters/numbers. So I followed his
instructions to the letter.
For the most part, it works and works perfectly. But about 4 out of
the 15-20 entries I made pulled the wrong. Is there a way to finetune
the accuracy? Yes, was able to get the right data eventually by
fiddling with cell format and switching from text to general to number
and back to text until the correct data popped in but I can't keep
doing it that way for the problem ones. One day I won't recognize
that the information is incorrect. I have so few entries at this time
that it was easy to pick up the mistake yesterday.
The VLOOKUP formula is a simple one:
=VLOOKUP($D2,GrandToy2008,2)
Hoping that there's just something simple I'm missing to increase
accuracy. I seem to remember seeing something that would tell Excel
that only 1 item was possible for each entry since sometimes one would
need to have several entries per product ID, i.e., when something like
"desk" is used to cover the various types of desks there might be. In
this case, only 1 item per product ID. Hopefully it's something that
simple to fix the problem. I haven't been able to find that message
again. I'm sure the reference was in one of the ones that came up in
google yesterday.
Thanks!
D