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?

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?
.

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?
.

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?

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?
.