Vlookup

  • Thread starter Thread starter Kopel
  • Start date Start date
K

Kopel

I have on list 1 with the name of the streets (no number)
on column A and on column B the name of the city.

I have another list 2 with the name of the strees (with
number).

If a use Vlookup to find the street of list 2 on list 1 and
give the name of the town will not work because the streets
on list 2 have numbers.

Can I use wild card on the formula so I can keep the street
number? If yes what is the formula? If no, any suggestion?

Thank You

Kopel
 
Assuming that the lookup value (A1 in this case) is the street name without
numbers you can use wildcards

=VLOOKUP("*"&A1&"*",Sheet2!B2:C20,2,0)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top