if statement - Excel 2010 if condition occurs in column -

i not sure how call title, think describes it.

i want make table in excel 2010 , looks following:

table1:

no. | name | hours available | leftover hours |
1 | john | 40 |   |
2 | pete | 35 |   |
3 | jane | 24 |   |

table2:

no. | client | hours needed | who? |
1 | client 1 | 4 | john |
2 | client 2 | 16 | jane |
3 | client 3 | 8 | pete |
4 | client 4 | 9 | john |

in column 'leftover hours' in table 1, want formula take place. formula has check according name of it's row, in table 2 if occurs there, , if occurs, take 'hours needed'. take 'hours available' , subtract 'hours needed' , output result in 'leftover hours'.

in example; john should have 27 leftover hours, pete should have 27 leftover hours , jane should have 8 leftover hours.

i hope try accomplish clear , appreciate if willing me.

extra column (e) in table 2, fill down: =sumif($d$2:$d$5,d2,$c$2:$c$5)

last column in table 1, fill down: =c2-index('table 2'!e:e,match('table 1'!b2,'table 2'!d:d,0),0,1)