search function

[crodriguez1976]

Is there a way to search an entire column for specific information? (Ex:
search a column for the word "item") Then, display the word I searched for in
another sheet? After displaying the result , is it possible to display
specific cells in the same row the word was found in excell?

[Franz Verga]

crodriguez1976 wrote:
> Is there a way to search an entire column for specific information?
> (Ex: search a column for the word "item") Then, display the word I
> searched for in another sheet? After displaying the result , is it
> possible to display specific cells in the same row the word was found
> in excell?


Maybe you are looking for VLOOKUP function... Check the online help...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

[Ken Wright]

Various ways to search, including the COUNTIF(), SEARCH(), ISNUMBER(SEARCH())
functions. To return a value in the same row you would normally use VLOOKUP
if the value to be looked up is to the right of your column containing your
search word, or you would use a combination of INDEX() and MATCH() if it is
to the left. Help topics in Excel on all of these are quite good.

Function combinations such as ISNUMBER(SEARCH()) and INDEX() and MATCH()
aren't as intuitive as the others, but post back if you get stuck.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)



"crodriguez1976" wrote:

> Is there a way to search an entire column for specific information? (Ex:
> search a column for the word "item") Then, display the word I searched for in
> another sheet? After displaying the result , is it possible to display
> specific cells in the same row the word was found in excell?
>
>

[crodriguez1976 via OfficeKB.com]

Thank you very much for your help. I ended up using Index() Match() and it
seemed to work, but now I have another problem. Sometimes I enter more than
one item in a cell. (Ex: The title of my table could be ITEM and below in
that column I could have one or more items in each cell.) Is there a way to
look for part of a cell? (Ex: I might have "1.2.3" and "5.6.7" all in one
cell) Can I look for "5.6.7" only and still get the information within that
row? Right now, with Index() Match() it seems I have to have the entire "1.2.
3" and "5.6.7" to get anything.

Maybe it would be easier to just seperate each item in it's own cell, but
that could mean up to 30 columns sometimes.

Ken Wright wrote:
>Various ways to search, including the COUNTIF(), SEARCH(), ISNUMBER(SEARCH())
>functions. To return a value in the same row you would normally use VLOOKUP
>if the value to be looked up is to the right of your column containing your
>search word, or you would use a combination of INDEX() and MATCH() if it is
>to the left. Help topics in Excel on all of these are quite good.
>
>Function combinations such as ISNUMBER(SEARCH()) and INDEX() and MATCH()
>aren't as intuitive as the others, but post back if you get stuck.
>
>> Is there a way to search an entire column for specific information? (Ex:
>> search a column for the word "item") Then, display the word I searched for in
>> another sheet? After displaying the result , is it possible to display
>> specific cells in the same row the word was found in excell?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200608/1