Hi
You haven't really given us much to go on. But if all of your data lines
have a unique identifier, you could use VLOOKUP to do your searching.
Maybe if you supplied more info, examples, etc. the answer would be more
specific.
Regards
Michael Mitchelson


" wrote:

Trying to figure out how to do this. Lets say I have a large excel
workbook...maybe 20 pages.....100 rows in each.
I want to look up a name in column B....and return all of this name
along with the data in an adjoining column. Hope this makes sense.
Thank you.