G G.P.N.L. c.v.a. Dec 27, 2009 #1 How can I get a match with VLOOKUP("TBS";a1:c15;2) if in the Table_array the data is "TBS XYZ" ?
P Pete_UK Dec 28, 2009 #2 Try this: =VLOOKUP("TBS*";a1:c15;2;0) The asterisk is a wildcard character, meaning any characters. Hope this helps. Pete
Try this: =VLOOKUP("TBS*";a1:c15;2;0) The asterisk is a wildcard character, meaning any characters. Hope this helps. Pete
