Cross Reference

  • Thread starter Terrance DeBord
  • Start date
T

Terrance DeBord

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.
 
D

DaveO

Should be a simple VLOOKUP ie...

In cell D2 enter this...

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

HTH
 
Top