How do you write a lookup function if the range you are pulling from contains more cells than the data field you are looking up? EX:

I have one "spreadsheet A" with a list of names pulled from "spreadsheet B" and some others added. How do I write the function in spreadsheet B to lookup the values that appear in spreadsheet A so that I can drag the formula and find the adjacent value for those that appear in apreadsheet A?