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
Hello,
Better yet to avoid such scenario. Can’t you either use drop down list values or store id instead?
Br,
Anders
