On sheet 1, I have a list of names in one column (a) and rep #s in second
column (b). On sheet 2, I have list of names (in different order and some
may be on one list and not the other), and want to match up the rep# to
correct name from searching sheet 1.

So... if cell A1 in sheet 1 = any of the fields in sheet2 then determine
which row it's in and enter the data from the b column of that row.