Vlookup with multiple creteria

Hi to all,

i have list of employee leave details, i need to map it to muster roll,,,

note: Same employee has taken two three times leave for multiple reason. example 200758 has taken leave for two times for different days... i need to map this memo tour to his attendance (july 1st and 2 nd and also 29th, 30th ,31st of that month)

Personnel No Name Begin Date End Date Subtype Text
200680 Rajaraman J 7/26/2013 7/26/2013 Emergency Leave
200758 Satpute Sunil 6/21/2013 7/2/2013 ODD - Memo Tour
200758 Satpute Sunil 7/29/2013 8/4/2013 ODD - Memo Tour
200823 Joshi Atul 6/14/2013 7/3/2013 ODD - Memo Tour
200823 Joshi Atul 7/16/2013 7/22/2013 ODD - Memo Tour
200999 Tank Sanjay SHAMJIBHAI 7/12/2013 7/19/2013 ODD - Memo Tour
200999 Tank Sanjay SHAMJIBHAI 7/5/2013 7/5/2013 ODD Memo tour
200999 Tank Sanjay SHAMJIBHAI 7/8/2013 7/10/2013 ODD Memo tour
201026 Deshmukh R V 7/12/2013 7/16/2013 Privilege Leave
201057 Joshi Ashutosh 7/22/2013 7/31/2013 ODD - Memo Tour
201072 Joshi Ajit 7/3/2013 7/3/2013 Emergency Leave
201105 Sathe Sudhir CHANDRAKANT 7/24/2013 7/27/2013 ODD - Memo Tour
201108 Adhikari Syamal 7/14/2013 7/19/2013 Seminar / Training
201108 Adhikari Syamal 7/8/2013 7/8/2013 Emergency Leave
201118 Prakash S Rao 7/11/2013 7/11/2013 ODD - Memo Tour
201118 Prakash S Rao 7/10/2013 7/10/2013 ODD - Memo Tour
201439 Lawande Arvind 7/18/2013 7/29/2013 ODD - Memo Tour
201669 Kamat S M 7/19/2013 7/23/2013 ODD - Memo Tour
202120 Aravapalli Srinivas 7/1/2013 7/3/2013 ODD - Memo Tour
202176 Kirty Apurbo 7/1/2013 7/2/2013 ODD - Memo Tour
202176 Kirty Apurbo 7/17/2013 7/23/2013 ODD - Memo Tour
202176 Kirty Apurbo 7/29/2013 8/2/2013 ODD - Memo Tour


Thanks in advance

regards,
sathya