I'm not sure what you are after - can you post some examples of your
data?

Pete

On Nov 25, 11:01*pm, Old Keith
wrote:
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.