Search function (text or numerical)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

marciac - 07 Jul 2006 12:29 GMT

Hi all
Just trying to figure out how to implement a search function, as
follows...

sheet1 contains all the data to be searched;
example:
one cell in this sheet contains "BMS-1865-1701-CZ05"

How can I search for this data, based on partial search criteria ? for
example my criteria would be : "1701-CZ"

I really need to use excel on this one...
Thnx!

Signature

marciac

Reply to this Message

daddylonglegs - 07 Jul 2006 12:40 GMT

Do you know the range of cells in which the data might be found. Is i
one row or column or a larger range?

Which data do you want to return, e.g. the cell immediately to th
right

Reply to this Message

marciac - 07 Jul 2006 13:06 GMT

Hi :)

Images speak more than words!

'[image: http://img143.imageshack.us/img143/2286/screenshot0012wn.jpg]
(http://imageshack.us)

On a much larger scale (like 50 columns, 50 rows)
I need to:
1. Find for example, the phone number related to BMS-485-56. But th
search criteria I get to perform the search is partial, something lik
"485-56" or "BMS"

Reply to this Message

marciac - 14 Jul 2006 07:51 GMT

Heeeelp...

Signature

marciac

Reply to this Message

Dave Peterson - 14 Jul 2006 14:54 GMT

What's wrong with selecting your range,
then Edit|Find
click on the Options button (if you don't see the options) and make sure that
match entire cell contents is not checked.

> Heeeelp...
>
[quoted text clipped - 3 lines]
> marciac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36151
> View this thread: http://www.excelforum.com/showthread.php?threadid=559270

Signature

Dave Peterson

Reply to this Message