Xlookup or Vlookup wild card lookup when the lookup criteria string is longer than the data|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi All,

I use the below formula to find out if a Store Name on a complaints report comes from a depot we supply.

The problem is the Daily_Stores table comes from a query that collates data from our customer csv files and the Store Name field is free text there end so we sometimes get incorrectly spelled or described names

=XLOOKUP("*"&Daily_Stores[@[Store Name]]&"*",Depot_Stores[StoreName],Depot_Stores[DepotName],"N/A",2)

My current issue is when the Daily_Stores Store Name is longer than the true Depot Stores name eg

MONKS CROSS SF where the true stores name is Vangarde Monks Cross if the SF isnt there it finds and shows the correct depot

I guess I want a partial match of a partial match

regards

John