Pull data from another sheet based on certain criteria

I have a spreadsheet with multiple rows of information. How can I pull all
rows of info based on certain criteria, into another spreadsheet.

Sheet1
Name1, Data, Data, Data
Name2, Data, Data, Data
Name1, Data, Data, Data
Sheet 2
Name1, Data, Data, Data
Data, Data, Data

use the vlookup function copied across changing the col no as required
--
paul
remove nospam for email addy!



"steve_sr2" wrote:

> I have a spreadsheet with multiple rows of information. How can I pull all
> rows of info based on certain criteria, into another spreadsheet.
>
> Sheet1
> Name1, Data, Data, Data
> Name2, Data, Data, Data
> Name1, Data, Data, Data
> Sheet 2
> Name1, Data, Data, Data
> Data, Data, Data