excel - Check if cells match in two columns and, if they do, copy a related value -

given column a of 100 names , b of numbers, column c contains subset of numbers how might populate column d matching name? match names in a , d next same number. example, a, b , c inputs , d desired output:

  ____a______b_______c_______d____ 1 |larry | 11111 | 22222 | bob   | 2 |bob   | 22222 | 44444 | steve | 3 |mike  | 33333 | 55555 | jim   | 4 |steve | 44444 |       |       | 5 |jim   | 55555 |       |       | 

please try in d1 , copied down suit:

=index(a:a,match(c1,b:b,0))