How's this Pete ?
Supplier list Value I want this to return just ABC
ABC Perth 200 =VLOOKUP(C5,range1,1) ABC
Brisbane ABC 432 =VLOOKUP(C6,range1,1) ABC
ABC 762 New Zealand 123 =VLOOKUP(C7,range1,1) ABC
Canadian ABC 543 =VLOOKUP(C8,range1,1) ABC


Named range:
range1
ABC
qantas
Emerites
etc,


"Pete_UK" wrote:

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.