Find The Name Vlookup Or Match

I am trying to insert a formula to find the name (match?) from one column on say sheet 3 and return the value in the next column.

column a sheet 1
my name
your name
someone else

I would like it to search sheet 3 column a and return value sheet 3 column b

as sheet 3 would look like this

col a / col b
john q / 11a
my name / 13b
someone else/ 9a
your name/ 12b

What my goal is - is to only have to enter the column b in sheet 3 one time per name and have it fill in on sheet 1 for every entry of multiple entries of the same name in column a if that makes sense.

I know this should be simple- I want to avoid the if statement as there will be about 50 names to sort and return the proper class (column b)