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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up A name in a table and reurning all rows that are associ 3
Vlookup and return sheet name also 2
Vlookup to reference offset 1
Lookup / Summary Table 8
Odd Lookup 1
match first and last name and insert column into existing sheet 1
use cell text in lookup function 3
colating data from a table - for bespoke report 4

Top