VLOOKUP with partial match

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" ?
 
P

Pete_UK

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
With F1 value, look at A, if match or partial match return B 5

Top