I have a supplier list containing some suppliers with a number of branches
with slightly different names but with one identical element. This one
element is in my range name, and that's what I want vlookup to return so as
to treat all branches as one entity. All help welcome.