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!
Bookmarks