Results 1 to 4 of 4

Excel 2007 : Help with a lookup that will return multiple occurrences

Threaded View

  1. #1
    Registered User
    Join Date
    12-08-2009
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Help with a lookup that will return multiple occurrences

    Hi,
    I'm trying to figure out how to do a lookup that will return multiple occurrences. I searched the forums and tried to manipulate a function that was used to answer someone else's question, but it isn't working properly. Attached is a sample of what I'm trying to do. There are 2 sheets List and Flags. I would like to lookup the Number (Column C on List) and return all the Codes (Column H on Flags) in cells k-whatever on the List sheet. Hopefully, that made sense. The formulas I have in List K2:R4 and Flags J2:J24 are the formulas I was trying to make work. If I can get those to work that would be fine or if there is a better way to do it that would be great too. Thanks in advance for any guidance you can provide.
    Attached Files Attached Files
    Last edited by PHo1010; 12-11-2009 at 12:56 PM.

Thread Information

Users Browsing this Thread

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

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