Really need some help to determine what function/formula to use.
Table A contains names of Learners and their job functions. The same learner
could be there twice, and some learners have no job funtion.
Learner Name Job Function
A, EASWAR Marketing
A, EASWAR Marketing
Aarts, Hans
Abib, Marcelo Research
Abib, Marcelo Research
Abo El Azayem, Mohamed HR
Abou-Taleb, Khaled Marketing
Aceña Garcia, Luis Sales

The second table just has learner names. I need to pull the job function
from the other table to this. However, note that there could be someone on
this list that is not in the list above, or again, in here twice.
Learner Name
A, EASWAR
A, EASWAR
Art Jones
Abib, Marcelo
Abib, Marcelo
Abo El Azayem, Mohamed
Abou-Taleb, Khaled
Cat Smith