If your search data doesn't match the lookup table, you're not going to get matches.

You could also try:

=VLOOKUP(TRIM(C2)&"",Sheet2!A:C,3,FALSE)


Regards