something like:

=vlookup("*dog*",sheet2!$a:$b,2,false)
or
=vlookup("dog*",sheet2!$a:$b,2,false)
(if it has to start with dog.)



"ian123 <" wrote:

I've only ever used vlookups to search for exact matches - is it
possible to search for entries that are partial matches or contain some
of the words?

Eg, if i vlookup dog all i get back is the appropriate value for an
exact match of dog... however i need the lookup to pick up any matches
containing dog eg dog, doggy, doggie, dog123 etc

Anyone know if this is possible? Cheers

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson