I am trying to lookup a persons name in a table.
 

I am trying to lookup a persons name in a table. Then return ALL the rows
that are associated with that name. HELP.
IE:
Sheet1-A2 has the name I'm looking for
The array is on Sheet2-A1:G16
The name shows only one in the sheet2 column A ( like a pivit table)
The information I need is in that row and 3-4 rows below in column B
What I need is something like a Vlookup then Offset to find the rows below
the found name.

I am trying to lookup a persons name in a table.
 

See your other post.

Biff

"David A." wrote in message
...
I am trying to lookup a persons name in a table. Then return ALL the rows
that are associated with that name. HELP.
IE:
Sheet1-A2 has the name I'm looking for
The array is on Sheet2-A1:G16
The name shows only one in the sheet2 column A ( like a pivit table)
The information I need is in that row and 3-4 rows below in column B
What I need is something like a Vlookup then Offset to find the rows below
the found name.