View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Southin Joe Southin is offline
external usenet poster
 
Posts: 1
Default How can I compare a list of strings, allowing positive matching b.

I'm interested in being able to compare strings, and returning a positive
match has been found (e.g. tree = trees). Just stripping of the last "s"
does not work when irregular plurals are included (e.g. consider geese and
goose, matches and match). I'm interested in a function similar to VLOOKUP,
but with this added functionality.

Is there a way of consulting a complete list of plurals, contained in a
library, or something similar? The English language can be a bit of a bitch
sometimes.

Has anyone ever encountered anything similar??

I'm using MS EXCEL 2003 (PC), if that helps.

Many thaks in advance.