Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
search function
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
search function
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
search function
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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
search function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel search function | Excel Discussion (Misc queries) | |||
Search function. | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
VLookup function to search an entire workbook | Excel Worksheet Functions | |||
Search function | Excel Discussion (Misc queries) |