VLOOKUP with partial match

[G.P.N.L. c.v.a.]

How can I get a match with VLOOKUP("TBS";a1:c15;2)
if in the Table_array the data is "TBS XYZ" ?

 

[Pete_UK]

Try this:

=VLOOKUP("TBS*";a1:c15;2;0)

The asterisk is a wildcard character, meaning any characters.

Hope this helps.

Pete