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:

Name	Dept	Age
Henry	501	28
Stan	201	19
Mary	101	22
Larry	301	29
Lynn	201	22
Harry	401	21
Joe	101	23
Lynn	301	30

<colgroup><col><col><col></colgroup><tbody>
</tbody>

The search Criteria would be "Lynn"

The idea result would be:

Name	Dept	Age
Lynn	201	22
Lynn	301	30

<colgroup><col><col><col></colgroup><tbody>
</tbody>

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