Adding user name associated with user id

[fourlugas]

I have a worksheet that is a query of tickets in my queue. One of th
columns is called Status_History_Acknowledged_USER.

That gives a user ID

I have another worksheet that has all of the user ID's and the name o
the user

On worksheet 1, I'd like to add a column that looks up that user id an
puts their name next to that entry. Is there a way to do that? I ca
do some formulas and such but this is stumping me

 

[Myrna Larson]

Check out the VLOOKUP function in Help. It should do what you want.

 

[Frank Kabel]

Hi
in B1 on your first sheet enter
=VLOOKUP(A1,'other_sheet'!$A$1:$B$1000,2,0)
and copy down for all rows

 

[Ken Wright]

Use VLOOKUP:-

Assuming your S_H_A_U column is on Sheet1 in Col A, starting A1 (Header), and
your other data is in sheet2 in the range A1:B100 (A = USERID, B= Name)

In B2 on Sheet1 put =VLOOKUP(A1,Sheet2!$A$1:$B$100,2,0) and copy down