You could use MATCH with wildcards
=MATCH("*Adden*",A:A,0)
--
HTH
Bob Phillips
"Benn" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I'm trying to set up a search function that can return non-exact matches,
> for example I have a database of hospital account details, I have already
set
> up a search by name facility that will bring up all the details of the
> account when you accutrately type in the hospital name. But to make it
more
> user freindly I need to search on partial names, eg. to get Addenbookes
> Hospital I currently need to enter Addenbrookes Hospital exactly the same.
> But I want to be able to search on Addenbrookes, or Adden or brookes......
> and it still return the correct or nearest match.
>
> Please help if you can this is driving me NUTS!!
> TIA
> Benn
Bookmarks