Tom corrected this response.

If you're tring to add the values returned by the =vlookup()'s, you could use
the userdefined function in this thread:

http://groups.google.com/groups?thre...EADA%40msn.com

And then wrap it in =sum()

=sum(mvlookup("*dog*",sheet2!$a:$b,2,false))

If you're returning text or want to see the individual values, you can select as
many cells (in a row or in a column) that you expect to return and then hit
ctrl-shift-enter (instead of just enter).



Dave Peterson wrote:

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


--

Dave Peterson