Results 1 to 5 of 5

Return all row information consist of the look up value

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2015
    Location
    SG
    MS-Off Ver
    2007
    Posts
    21

    Return all row information consist of the look up value

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Return all row information consist of the look up value
    By reeNce in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-20-2015, 07:57 AM
  2. Get the highest value when all values consist of letters AND numbers
    By LinaVa in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-18-2014, 10:48 AM
  3. [SOLVED] Macro to copy data from a row (consist of multiple columns) into to single column
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-06-2013, 06:25 PM
  4. [SOLVED] split 1cell that is consist of date and time to 2column
    By sr_88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2013, 05:46 AM
  5. To Call All Value Exclude value consist of special words
    By cyee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-27-2013, 06:12 AM
  6. Replies: 2
    Last Post: 01-05-2013, 12:42 AM
  7. find the same number consist in 2 cells in one column
    By rsami in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2011, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1