hi,
you can't. the lookup functions in excel only return the
value in a single cell.
to do what you want you are possible looking at a macro.

-----Original Message-----
I am trying to setup anohter sheet in Excel and have it
do a lookup in the
first, and return all of the rows which meet the criteria
( Value in column
A). How can I do this?
.