Results 1 to 6 of 6

Displaying multiple results using VLOOKUP or similar

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2009
    Location
    Heysham, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Displaying multiple results using VLOOKUP or similar

    Hi,

    I've searched through 20 pages and found a thread that I thought would solve my problem, however the result didn't make sense so here goes with my problem:

    My music collection is recorded in excel. I have a worksheet for ‘tracks’ and another worksheet for actual ‘records’.
    Within my tracks spreadsheet I want a formula in the last column against each track which denotes the corresponding actual record I.D. number (Column I)

    In the Tracks spreadsheet, column H I've Concatanated to give a more unique reference. Column I is a Look Up formula but obviously only finds the first instance.

    The problem is, I do have different versions of the same track eg. 7”, LP, Compilation LP etc. So Look Up only finds the first exact match, whereas I need a formula that finds all matches in my ‘Records’ spreadsheet for the particular track. I know a possible solution is to use the Find function, but with over 10,000 tracks that’s a lot of finding, plus if I sell a record I want it’s reference to be automatically removed from its corresponding place in the tracks spreadsheet, and I’m sure given all Excels capabilities there should be a formula for this!?
    Eg. In my Tracks spreadsheet Line 2, column I, should show result: 1.3, 6

    Is there a way?

    I've attached a small example file for ease of understanding.

    Thanks in advance!
    Attached Files Attached Files

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