vlookup in excel 2007

  • Thread starter Thread starter Old Keith
  • Start date Start date
O

Old Keith

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.
 
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,
 
Back
Top