retrive detail from multiple data

[punit83]

Hello

This is my data file

L01354	Round
L01355	Round
L01356	Round
L01357	Round
GL01358	Round

<tbody>
[TD="class: xl70"]Stone #[/TD]
[TD="class: xl70, width: 121"]Ref[/TD]
[TD="class: xl70, width: 116"]Document No[/TD]
[TD="class: xl70, width: 146"]Customer Ref No.[/TD]
[TD="width: 125"]Product #[/TD]
[TD="width: 125"]Shape Name[/TD]
[TD="class: xl70, width: 84"]Report #[/TD]
[TD="class: xl70, width: 90"]Seal No[/TD]
[TD="class: xl70, width: 90"]Size[/TD]
[TD="class: xl71, width: 85"]Pcs[/TD]
[TD="class: xl72, width: 79"]Weight[/TD]
[TD="class: xl70, width: 146"]Color[/TD]
[TD="class: xl70, width: 64"]Clarity[/TD]

[TD="class: xl70"]L01354
[/TD]
[TD="class: xl70"]2217
[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]

[TD="class: xl70"]1243777[/TD]
[TD="class: xl70"]1243777[/TD]
[TD="class: xl70"] +1.00-1.49[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl72"]1.02[/TD]
[TD="class: xl70"]K[/TD]
[TD="class: xl70"]VS2[/TD]

[TD="class: xl70"]L01355
[/TD]
[TD="class: xl70"]2217
[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]

[TD="class: xl70"]1243965[/TD]
[TD="class: xl70"]1243965[/TD]
[TD="class: xl70"] +0.50-0.69[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl72"]0.50[/TD]
[TD="class: xl70"]J[/TD]
[TD="class: xl70"]VS2[/TD]

[TD="class: xl70"]L01356
[/TD]
[TD="class: xl70"]2217
[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]

[TD="class: xl70"]1243959[/TD]
[TD="class: xl70"]1243959[/TD]
[TD="class: xl70"] +0.50-0.69[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl72"]0.50[/TD]
[TD="class: xl70"]J[/TD]
[TD="class: xl70"]VS2[/TD]

[TD="class: xl73"]L01357
[/TD]
[TD="class: xl70"]2217
[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]

[TD="class: xl70"]1243502[/TD]
[TD="class: xl70"]1243502[/TD]
[TD="class: xl70"] +0.50-0.69[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl72"]0.50[/TD]
[TD="class: xl70"]I[/TD]
[TD="class: xl70"]SI2[/TD]

[TD="class: xl70"]L01358
[/TD]
[TD="class: xl70"]2217[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl70"][/TD]

[TD="class: xl70"]1242910[/TD]
[TD="class: xl70"]1242910[/TD]
[TD="class: xl70"] +0.40-0.49[/TD]
[TD="class: xl71"]1[/TD]
[TD="class: xl72"]0.43[/TD]
[TD="class: xl70"]I[/TD]
[TD="class: xl70"]VS2[/TD]

</tbody>

and in another worksheet i am using index& match formula to find detail of particular data

[TABLE="width: 1064"]
<tbody>[TR]
[TD]Input 1[/TD]
[TD]Input 2[/TD]
[TD]Shape
[/TD]
[TD]Seal No[/TD]
[TD]Product #[/TD]
[TD]Shape2[/TD]
[TD]Color[/TD]
[TD]Clarity[/TD]
[TD]Size[/TD]
[TD]Weight[/TD]
[/TR]
[TR]
[TD]L01354
[/TD]
[TD]1243777[/TD]
[TD][/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]

Here is there any formula that if i input query 1 or 2 (any1) than it shows result for rest of criteria :-[TABLE="width: 1064"]
<tbody>[TR]
[TD]Shape
[/TD]
[TD]Seal No[/TD]
[TD]Product #[/TD]
[TD]Shape2[/TD]
[TD]Color[/TD]
[TD]Clarity[/TD]
[TD]Size[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance