Index, Match Help

[five0s]

Here is the situation:

I have two worksheets.

Sheet1 has a list of user names in colA
Sheet2 has a list of user names in colA, with the corresponding Person
in colB.

How can I have it match the user names up and then return the
corresponding person name to sheet 1, so that it will also list the
persons name, not just the username.

Hope I am making sense.

SHEET1
A1: PTJSM
A2: PTZDP
A3: PTHLC
A4: PTPDJ

SHEET2
A1: PTPDJ B1aul Jones
A2: PTHLC B2: Harrie Carry
A3: PTJSM B3: Jimmie Maxwell
A4: PTZDP B4: Zach Pox

Also, I would like for it to return nothing, just be blank, if their
is no corresponding match.

 

[Bob Phillips]

=VLOOKUP(Sheet1!A2,SHeet2!A:B,2,False)

 

[five0s]

=VLOOKUP(Sheet1!A2,SHeet2!A:B,2,False)

--
__________________________________
HTH

Bob

That did it!

Thanks a bunch.