Cross Reference

I have a sheet that has the following
Col A: - UserID
Col B: - Full Name
Col C: - UserID that issue is assigned to

I want to take a cell from Col C, find it in Col A, take the Associated
value in Col B and finally take the name found(based on the ID looked up) and
fill in a Cell in Col D.

Basically this is just a ID/Name lookup but I just can't get it to populate
Col D correctly.

Should be a simple VLOOKUP ie...

In cell D2 enter this...

=VLOOKUP(C2, A:B, 2, False)

HTH

"Terrance DeBord" wrote:

> I have a sheet that has the following
> Col A: - UserID
> Col B: - Full Name
> Col C: - UserID that issue is assigned to
>
> I want to take a cell from Col C, find it in Col A, take the Associated
> value in Col B and finally take the name found(based on the ID looked up) and
> fill in a Cell in Col D.
>
> Basically this is just a ID/Name lookup but I just can't get it to populate
> Col D correctly.