indexing - INDEX AND MATCH FUNCTION -DATES INVOLVED -

i need please index , match involving dates.

table 1

empl. code   name         bonus date  1000         smith        1/10/2014 1000         smith        1/6/2014 1000         smith        1/1/2014 2000         aero         1/16/2014 2000         aero         1/11/2014 5000         jethro       1/23/2014 8000         tull         1/18/2014   

table 2

empl code    name         absent date 2000         aero         1/20/2014 1000         smith        1/10/2014 1000         smith        1/6/2014 8000         tull         1/18/2014 

table 1 has names , date employee received bonus.
table 2 has names of employees absent on given dates

objective: create column in table 1 showing if there match between 2 dates, (table 1, bonus date) , table 2 (absent date) particular employee, place date ( formula result) beside employee name . tell enmployee, being absent on date, doesnt deserve bonus. if absent date doesnt apply teh bonus date employee, #na value in appropriate cell beside employee bonus date.

sample /desired) result:

empl. code   name         bonus date     result 1000         smith        1/10/2014     1/10/2014 1000         smith        1/6/2014      1/06/2014 1000         smith        1/1/2014      #na 2000         aero         1/16/2014     1/16/2014 2000         aero         1/11/2014     #na 8000         tull         1/18/2014     1/18/2014 

note: table 1 should retain original lineup. hope can help.

ericv