Rick and all,

I think I just identified my problem, but have not figured out a way around
it.

In my text column the hyphen does come into play so to speak, here is why.
I have a person who is in charge of a group of people, so what I have done is
use the name of the leader, then a hyphen and then his worker. Here is a
example or two: [David-Paul, David-Steve, David-Saul, David-Tim]. Now the
workers can go between the leaders, so it could also be [Frank-Paul,
Frank-Steve, Frank-Saul, Frank-Tim]. BTW the text column is sorted in
ascending order.

So what I believe the problem is that the vlookup function can not match the
names because it sees the same name mutilate times as the first name.

Is this correct, and if so how would I fix the problem?