Partial String match in array that returns a value against another column

[yehlo]

Hi I have 2 sheets in my workbook. Sheet 1 has list of IDs and incomplete cells in address field. In my sheet 2 I have Another list of addresses that are fully written and I want to mark the ID if I think that it is matches. The address in sheet 2 can repaeat and evertime the same id is to be mark against it.
Is there a way to solve this problem through excel?


Sheet 1
[TABLE="width: 443"]
<tbody>[TR]
[TD="class: xl64, width: 81"]Id[/TD]
[TD="width: 362"]Address[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 443"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]19466522[/TD]
[TD]WORK CENTER-A[/TD]
[/TR]
[TR]
[TD]19466711[/TD]
[TD]SANJAY GANDHI HOSPITAL[/TD]
[/TR]
[TR]
[TD]19466743[/TD]
[TD]H-BLOCK[/TD]
[/TR]
[TR]
[TD]19466744[/TD]
[TD]NDDB[/TD]
[/TR]
[TR]
[TD]19466745[/TD]
[TD]S/S NO-15[/TD]
[/TR]
[TR]
[TD]19466746[/TD]
[TD]O-BLOCK[/TD]
[/TR]
[TR]
[TD]19466885[/TD]
[TD]B-BLOCK RED LIGHT[/TD]
[/TR]
[TR]
[TD]19467063[/TD]
[TD]BC-BLOCK[/TD]
[/TR]
[TR]
[TD]19467185[/TD]
[TD]L-BLOCK[/TD]
[/TR]
[TR]
[TD]19467705[/TD]
[TD]E1-BLOCK[/TD]
[/TR]
[TR]
[TD]19467706[/TD]
[TD]M-BLOCK[/TD]
[/TR]
[TR]
[TD]19467707[/TD]
[TD]E-BLOCK[/TD]
[/TR]
[TR]
[TD]19467708[/TD]
[TD]F1-BLOCK
[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2

[TABLE="width: 564"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Address[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 564"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]E, S & J Block Mangolpuri JJ Cly. Z-515[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E-1 Block sutlan puri.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E-2 Market Sultan Puri[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E4 BLOCK,SULTANPURI SITE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E4 BLOCK,SULTANPURI SITE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E5 Block Behind Water Tank-Zon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E5 Block Behind Water Tank-Zon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E5 Block Behind Water Tank-Zon[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E-7 BLK Sultan Puri Z-518[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E7 Block Sultan Puri-Zone-518[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]E7 Block Sultan Puri-Zone-518[/TD]
[/TR]
</tbody>[/TABLE]