I have loads of data that I need to make available to loads of people. I am trying to build a funky search function for easy use. I am trying to have a field where you only have to type in part of a word and you be presented with the results!

So, for example, you enter 'Sheff' and you get Sheffield, Sheffield Forum, Sheffield United etc etc.

Any idea's??

do a search in excel on "lookup"

Tried the look up function and I can only get it to return one result. I need it to return several.

By typing 'Abbey' you get Abbeyfield, Abbeydale, Abbeyside etc etc.

Any clues

Search the 'Help' for 'filter' ... in particular 'filter a range'.
This sounds like what you are trying to achieve.

I used the website below and got good results

http://www.mrexcel.com/board2/index.php

Just a quick note....is excel necessarily the right tool?

No excel isn't the right tool. However, the people I need to make this information avaiable to don't have access to access - for example.

I got frustrated with the help text and have managed to find something on MrExcel (good call). I have it returning one field and 'jumping to' but are now trying to get it to show information from two or more related fields.

So near yet... Thanks you all the help folks!