Excel - matching values in columns in different tabs and then pasting into another column if there's a match

Solution 1:

Sheet 1 data

1   name 1
2   name 2
3   name 3
4   name 4
5   name 5
6   name 6

Sheet 2 data

name 3  today
name 4  Yesterday
name 5  a different day
name 6  tomorrow
name 7  never

Query in cell C1 of sheet 1, copie and paste down

=VLOOKUP(B1,Sheet2!A:B,2,FALSE)

Results

1   name 1  #N/A
2   name 2  #N/A
3   name 3  today
4   name 4  Yesterday
5   name 5  a different day
6   name 6  tomorrow