Need help with lookup

[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

 

[Dave Peterson]

=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 for the other columns.

 

[Dan B]

Awesome, that worked.

Thanks a ton!

=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 for the other columns.