VLOOKUP to return values based on partial text

Hi,

I am trying to get a vlookup to return values that contain SHERLOCK HOLMES. The table the vlookup looks at contains this:

ADVENTURES OF SHERLOCK HOLMES, THE - UK VERSIONS (13 X 60)
ADVENTURES OF SHERLOCK HOLMES, THE - UK VERSIONS (13 X 60)
CASEBOOK OF SHERLOCK HOLMES, THE - UK VERSIONS
MEMOIRS OF SHERLOCK HOLMES, THE - UK VERSIONS
RETURN OF SHERLOCK HOLMES, THE - UK VERSIONS
SHERLOCK HOLMES - THE ELIGIBLE BACHELOR - UK VERSION
SHERLOCK HOLMES - THE HOUND OF BASKERVILLES - UK VERSIONS
SHERLOCK HOLMES - THE MASTER BLACKMAILER - UK VERSION
SHERLOCK HOLMES - THE SIGN OF FOUR

The formula I am using is:

=VLOOKUP("*"&$B$2&"*",$A$2:$A$10,1,FALSE)

B2 = SHERLOCK HOLMES

So far the formula works but only returns the top most value from the table. If the formula is copied down the top most value is just repeated.

Anyone know how i can sort this so that it returns all of the individual values containing Sherlock Holmes and then display's N/A when no more are found?

Just one point to mention, i am working in Excel 2003 here due to it being at work. See attached file.

Help would be appreciated, thanks.