I have a workbook containing my cd collection, I would like to search for a song title to find the album title of the cd it appears on and return the result on sheet1
My cd's are listed 1 cd per column on sheet2
Cd titles are in row 2 on sheet2
The cell to search from is on sheet1
Any help is much appreciated
Bookmarks