Display occurrences of text and then display it on search page

Hi/Evening All

i have data on a sheet a list of video games and i would like to be able to type in the name or just a part name so for example just sonic rather then sonic 2 and 3 etc

is this possible with vlookup have tried the match function in the past but just said yes or no

thanks for the help