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