Results 1 to 11 of 11

Need to return multiple instances using lookup

Threaded View

fugee7 Need to return multiple... 10-31-2011, 03:28 PM
Richard Buttrey Re: Need to return multiple... 10-31-2011, 03:54 PM
fugee7 Re: Need to return multiple... 10-31-2011, 05:17 PM
Richard Buttrey Re: Need to return multiple... 10-31-2011, 06:13 PM
fugee7 Re: Need to return multiple... 10-31-2011, 06:53 PM
Richard Buttrey Re: Need to return multiple... 10-31-2011, 07:15 PM
fugee7 Re: Need to return multiple... 10-31-2011, 08:26 PM
Richard Buttrey Re: Need to return multiple... 11-01-2011, 05:48 AM
fugee7 Re: Need to return multiple... 11-01-2011, 01:59 PM
rylo Re: Need to return multiple... 11-01-2011, 01:20 AM
fugee7 Re: Need to return multiple... 11-01-2011, 02:11 PM
  1. #1
    Registered User
    Join Date
    10-20-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Need to return multiple instances using lookup

    I'm trying to return multiple data for a lookup criteria.
    I've see this example mentioned before but did not see the solution....

    dog labrador
    dog beagle
    cat siamese
    bird toucan
    dog poodle

    Column A has the type of animal and Column B had the breed.

    On Sheet 2, I am trying to pull all the breeds for "dog". Lookup/match "dog" and find all breeds: labrador, beagle, poodle in successive rows.

    How can I do this?

    Thanks!
    Attached Files Attached Files
    Last edited by fugee7; 11-01-2011 at 02:12 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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