Searching for a value return corresponding row

[melbwarrior]

Hi

I am looking to search for certain value and then return the associated row.

For example Sample Data:

[TABLE="width: 242"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Dept[/TD]
[TD]Age[/TD]
[/TR]
[TR]
[TD]Henry[/TD]
[TD="align: right"]501[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]Stan[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]19[/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]Larry[/TD]
[TD="align: right"]301[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD]Lynn[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]Harry[/TD]
[TD="align: right"]401[/TD]
[TD="align: right"]21[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]23[/TD]
[/TR]
[TR]
[TD]Lynn[/TD]
[TD="align: right"]301[/TD]
[TD="align: right"]30
[/TD]
[/TR]
</tbody>[/TABLE]

The search Criteria would be "Lynn"

The idea result would be:

[TABLE="width: 242"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Dept[/TD]
[TD]Age[/TD]
[/TR]
[TR]
[TD]Lynn[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD]Lynn[/TD]
[TD="align: right"]301[/TD]
[TD="align: right"]30
[/TD]
[/TR]
</tbody>[/TABLE]

So effectively returning all rows in the date set on where the Cell reads "Lynn".

Any help would be much appreciated.

Thanks

 

[footoo]

What about using Filter?

 

[melbwarrior]

What about using Filter?

Hi

I would be extracting from one data set into a specific worksheet.

Thanks