H Holly Carson Oct 27, 2009 #1 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?
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?
L Luke M Oct 27, 2009 #2 On sheet 2, formula inputted into column A =INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A$A,0)) Copy across as needed.
On sheet 2, formula inputted into column A =INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A$A,0)) Copy across as needed.
H Holly Carson Oct 27, 2009 #3 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.
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.
A Ashish Mathur Oct 27, 2009 #4 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
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
G Gord Dibben Oct 28, 2009 #5 Typo Try this............=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A:$A,0)) Gord Dibben MS Excel MVP
Typo Try this............=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A:$A,0)) Gord Dibben MS Excel MVP
