Return all row information consist of the look up value

[reeNce]

I had created a table and example as shown below. The result output I require, if Sheet 1 name matches reference from Sheet 2 then it should display all value and rows from it else blank.

ps. Below is an example, in actual fact Sheet 1 & 2 is actually a different spreadsheet.

(Sheet 1)

Name	Color	Hobby	Pet
Peter
Lissy
John

(Sheet 2)

Name	Color	Hobby	Pet
Peter	Green		Dog
Peter	Blue	Badminton	Cat
Peter	Black	Soccer	Monkey
John	Blue	Swimming
Mary	Red		Cow

The output that I want from Sheet 1

Name	Color	Hobby	Pet
Peter	Green		Dog
Peter	Blue	Badminton	Cat
Peter	Black	Soccer	Monkey
Lissy
John	Blue		Swimming

[thebellguy]

Please upload a sample xls(x) file so that we can take a look. Use the Go Advanced button and the paperclip icon. Ensure you remove identifying information if necessary. Thanks.

[reeNce]

I had attached a example. From the below example, I wan Sheet 1 to match Sheet 2 name and provide all column and row details into Sheet 1.

Example.xlsx

[peterrc]

Possible solution attached using named ranges, data validation and vlookups.

Regards

peterrc