each cell that holds that vlookup formula will return 100 (from the sample
data). Don't think vlookup is a viable approach to return multiple matches.

--
Regards,
Tom Ogilvy

Dave Peterson wrote in message
...
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