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
Bookmarks