Hi All,

I have a sheet (Sheet#1) formatted something like this:

Saadi
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open

Sam
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open

Norman
ID Document Name Date Status
1 xyz 12-21-2007 Open
2 xyz 12-21-2007 Closed
3 xyz 12-21-2007 Open


Now I want that when on sheet#2, I input any name from this Sheet#1 (e.g.
Saadi, Sam or Norman) in a specific cell, the information given in the cells
next to that name should be displayed.

Like When I enter Sam in that specific cell on Sheet#2 only the
information/data under same name should be populated. Can anybody help me in
this regard? Number of Rows and column are constant for all the Records (5
Rows, 5 Columns)

The name is written in a merged cell (5 columns) above the data cells of
that particular record.

--
Sheikh Saadi