Index Match

[Vertual Lord]

Hey,

I'm trying to make a search function in my music database in excel 2003.
Figured Vlookup won't work since that only looks in the first column.

See attachment.

All songs are in tabs ABC, DEF, ...
Sheet "Alles" gathers all songs from all the other sheets.
The reason I don't just use one sheet is that I don't want to have to scroll down to each letter to see the songs that are in there, I don't want to have a database with like 1500 rows (since I will be adding a lot more songs).


What I'd want to have is a search option in the "Zoeken" sheet.
Say I type "Always look on the bright side of life", it should look that up and show: "Monty Python" "(album)" "(year)"

However if I want to search for a performer, example Billy Talent, it should show me all of their songs, each with the album name and year. (about 50 songs).


Any help for this would be great,
thanks!