| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for keyword in sheet 1 and returning the whole row intosheet 2
Is it possible to search for a keyword in column A in sheet 1 and
return the whole row containing that keyword into sheet 2? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for keyword in sheet 1 and returning the whole row into
On sheet 2, formula inputted into column A
=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A$A,0)) Copy across as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Holly Carson" wrote: Is it possible to search for a keyword in column A in sheet 1 and return the whole row containing that keyword into sheet 2? . |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for keyword in sheet 1 and returning the whole row into
Thanks. It keeps giving me an error and I can't figure out how to fix it. I changed 'Sheet 1' and Keywords to reflect the right labels, but I dont know what else to do. On Oct 27, 12:51*pm, Luke M wrote: On sheet 2, formula inputted into column A =INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A$A,0)) Copy across as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Holly Carson" wrote: Is it possible to search for a keyword in column A in sheet 1 and return the whole row containing that keyword into sheet 2? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for keyword in sheet 1 and returning the whole row into
Typo
Try this............=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A:$A,0)) Gord Dibben MS Excel MVP On Tue, 27 Oct 2009 11:25:56 -0700 (PDT), Holly Carson wrote: Thanks. It keeps giving me an error and I can't figure out how to fix it. I changed 'Sheet 1' and Keywords to reflect the right labels, but I dont know what else to do. On Oct 27, 12:51*pm, Luke M wrote: On sheet 2, formula inputted into column A =INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A$A,0)) Copy across as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Holly Carson" wrote: Is it possible to search for a keyword in column A in sheet 1 and return the whole row containing that keyword into sheet 2? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for keyword in sheet 1 and returning the whole row into sheet 2
Hi,
You could use advanced filters. You may read up on the same in the Help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Holly Carson" wrote in message ... Is it possible to search for a keyword in column A in sheet 1 and return the whole row containing that keyword into sheet 2? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching for 2 values and returning the sum... | Excel Discussion (Misc queries) | |||
| Returning a text by searching the whole workbook | Excel Discussion (Misc queries) | |||
| Searching a column and returning a yes or no answer | Excel Worksheet Functions | |||
| LOOKUP returning value in cell above what I was searching for | Excel Discussion (Misc queries) | |||
| Searching and returning row number of a value | Excel Worksheet Functions | |||
Hybrid Mode
