Thanks for the reply. It works fine, except for one problem. Some of the
terms in the glossary have more than one word, eg:

Sheet 2 A1: <Dog hunting strategy
Sheet 2 B1: <The Dog tends to hunt in packs, but has a less advanced
stealth capabilities than the Cat

Sheet 1 A1: <The application of the Dog hunting strategy to the Cat is
usually unsuccessfull

The only thing I can think of is to list every combination of words
possible. In reality there are a maximum of 3 words in a glossary term.


Thanks,

Andrew


--
AndrewB
------------------------------------------------------------------------
AndrewB's Profile: http://www.excelforum.com/member.php...o&userid=31994
View this thread: http://www.excelforum.com/showthread...hreadid=517261