Need help with lookup

  • Thread starter Thread starter Dan B
  • Start date Start date
D

Dan B

Hi,

I have four columns of data. Column B is a list of names. I need a formula
that will like for a specific name in column B and give me the data on the
rows in columns A, C and D where it finds that name. Kind of like
sub-totalling by name in column B, but I want to duplicate the data to
another section of the spreadsheet.

Thanks for any help,
Dan
 
=index('sheet2'!a:a,match(x99,'sheet2'!b:b,0))

Change x99 to the cell that contains the name.
Change 'Sheet2' to the name of the sheet with the table.
Change A:A to C:C and D:D for the other columns.
 
Awesome, that worked.

Thanks a ton!

Dave Peterson said:
=index('sheet2'!a:a,match(x99,'sheet2'!b:b,0))

Change x99 to the cell that contains the name.
Change 'Sheet2' to the name of the sheet with the table.
Change A:A to C:C and D:D for the other columns.
Click to expand...
 
Back
Top