H
Holly Carson
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?
return the whole row containing that keyword into sheet 2?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Searching for keyword in sheet 1 and returning the whole row intosheet 2
L
Luke M
On sheet 2, formula inputted into column A
=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A$A,0))
Copy across as needed.
=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A$A,0))
Copy across as needed.
H
Holly Carson
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.
it. I changed 'Sheet 1' and Keywords to reflect the right labels, but
I dont know what else to do.
A
Ashish Mathur
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
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
G
Gord Dibben
Typo
Try this............=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A:$A,0))
Gord Dibben MS Excel MVP
Try this............=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A:$A,0))
Gord Dibben MS Excel MVP