VLOOKUP with partial match

  • Thread starter Thread starter G.P.N.L. c.v.a.
  • Start date Start date
G

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" ?
 
Try this:

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

The asterisk is a wildcard character, meaning any characters.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic col_index_num in VLOOKUP? 5
a function required 3
Splitting cell contents into other columns 1
VLOOKUP issue with #N/A - linked workbook 3
How do I reference a "range" for a specific table_array in VLOOKUP 3
vlookup with dynamic table_array 3
Lookup in raw and column concurrently 5
Vlookups not working 2

Back
Top