Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count how many persons in a month using a date | Excel Worksheet Functions | |||
caculate a persons age | Excel Worksheet Functions | |||
what formula do i need to calculate a persons age | Excel Discussion (Misc queries) | |||
Excel for Blind persons use | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |