VLOOKUP String

[brett316]

Hi,

Hoping someone can help me please?

I am trying to do a VLOOKUP on a string. I want to search an address (which may or may not include the full address, town etc), then check it against another worksheet (named lookup) and if they match (bear in mind they may be slightly different texts, one may have just the first line of the address another may have the full address) it will display a code next to the address in the lookup sheet.

Make sense?

Cheers

 

[brett316]

Thats meant to say in the new worksheet it will display the code (from lookup) which is relevant to the address.

 

[VoG]

Perhaps a Fuzzy Lookup http://www.mrexcel.com/forum/showthread.php?p=955137#974873