Hi,

I am trying to build a spreadsheet that contains a search function e.g.
If a user types text into a cell a range of data is then looked up and
any text strings that contain the typed text are returned in a table.

The issue I have is that I can only make this work by using either the
left right or mid functions. Ideally I would like the formula to be
(in laymans terms).......if the typed text is contained anywhere in a
text string please return the whole text string.

Any ideas???

To make this clearer for you all below is an example of how it
currently works,

If a user types in Basset, my formula counts the length (Len) of the
typed text (in this case 6), the first six characters from each entry
in my data page are returned (using the left function), these are then
compared to the typed text (basset) if they match they are then included
in my table.

The data I am using are addresses that have been entered incosistently
e.g. either 11 Basset or Basset 11, this is why I need to search the
whole text string as I would want the users to see all Bassets (there
could be more than 50 on each street) contained in the data list.

Ctrl F is not an option on this.

Any help would be most appreciated.


--
Jahunga
------------------------------------------------------------------------
Jahunga's Profile: http://www.excelforum.com/member.php...o&userid=15291
View this thread: http://www.excelforum.com/showthread...hreadid=319315

It sounds like you are looking at using the

Find
or
search

functions. eg find("yourtest","in this text")

Lance



"Jahunga" wrote:


Hi,

I am trying to build a spreadsheet that contains a search function e.g.
If a user types text into a cell a range of data is then looked up and
any text strings that contain the typed text are returned in a table.

The issue I have is that I can only make this work by using either the
left right or mid functions. Ideally I would like the formula to be
(in laymans terms).......if the typed text is contained anywhere in a
text string please return the whole text string.

Any ideas???

To make this clearer for you all below is an example of how it
currently works,

If a user types in Basset, my formula counts the length (Len) of the
typed text (in this case 6), the first six characters from each entry
in my data page are returned (using the left function), these are then
compared to the typed text (basset) if they match they are then included
in my table.

The data I am using are addresses that have been entered incosistently
e.g. either 11 Basset or Basset 11, this is why I need to search the
whole text string as I would want the users to see all Bassets (there
could be more than 50 on each street) contained in the data list.

Ctrl F is not an option on this.

Any help would be most appreciated.


--
Jahunga
------------------------------------------------------------------------
Jahunga's Profile: http://www.excelforum.com/member.php...o&userid=15291
View this thread: http://www.excelforum.com/showthread...hreadid=319315

Thanks, had just found the search function and it works perfectly.


--
Jahunga
------------------------------------------------------------------------
Jahunga's Profile: http://www.excelforum.com/member.php...o&userid=15291
View this thread: http://www.excelforum.com/showthread...hreadid=319315