Helo Biff.

Because the names are almost always spelled and formatted idfferently, or I
would have already followed this path.

Mark :)

"Biff" wrote:

Hi!

Since both sets of data contain the persons name why not just lookup the
name? The userid could be any one of three but the name is the same, right?

Biff

"NWO" wrote in message
...
Hello Esteemed Excel Community...

I thought I knew all about the VLOOKUP function, but...

Here's my deal...on one worksheet called SOURCE, I have two columns of
data,
named UserID and Name.

On another worksheet in the same file, named HOURS, I have 5 columns named
UserID1, UserID2, UserID3, Name, and Production Hours. The reason for the
three UserID* columns is because we are still using a BTrieve system and
some
users have up to three UserIDs to identify the same name.

So, what I am trying to do is to capture the Production Hours data for a
given employee based on the single UserID in the SOURCE worksheet, and
compare this value to the three UserID cells on the HOURS worksheet fore a
match, and then copy Production Hours value. The names should match with
a
given UserID with slight differences.

So, I know a =VLOOKUP formulasay in cell b3 on the SOURCE worksheet, would
work in the form =VLOOKUP(b1,HOURS!b1:b5,FALSE) would yield the proper
value
if I was just concerned with comparing one unique UserID to another unique
UserID, but how do I accomplish this with testing which one of the UserID
values matches, and then fetching the value if there is a match? Can this
be
done with the VLOOKUP function?

Thank you in advance.

Mark :)