list whole row data when cell matches

[zohaib]

Hello,

I have attached a sample workbook.
There are 2 sheets. sheet1 has all the data and sheet2 (results) is where the formula is needed.

The problem: how do I get a formula to find A1 (family) in sheet1 column D and return whole row and list down?

Thanks,
Zohaib

 

[Hui]

Zohaib

You can use the technique described here:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

The only issue is that, it requires a known location as opposed to you wanting to type it anywhere

I have implemented it with your data

Enjoy

 

[zohaib]

Thanks Hui for your help