Searching for keyword in sheet 1 and returning the whole row intosheet 2

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

Gord Dibben

Typo

Try this............=INDEX('Sheet 1'!A:A,MATCH("Keyword",'Sheet 1'!$A:$A,0))


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif Formulas 2
Countif 2
Format single words in cells 3
producing a report via a keyword - filtering and macros not suitab 1
Outlook Delete email in batches in Outlook 2016. 1
Search formula referencing range of keywords 5
Refernce 2 sheets & same columns & rows 8
matching 1 to 1 and 1 with variations... 3

Top