Identify who raised a ticket

[Excel4dummmmy]

I have a daily data export that currently only identifies who raised a ticket with the associate's staff ID rather than name.
I would like a formula to identify if their ID number down column B and populate in column C

Ticket number	Raised by	Associate Name
ABCDE1	123​	?
ABCDE2	456​	?
ABCDE3	789​	?

Any help would be appreciated

 

[Excel4dummmmy]

I have attached images of the two sheets

 

[Fluff]

Ok, assuming the "raised by" is in col B try

=vlookup(b2,sheet1!a2:b10,2,0)