How to search for a keyword and return the ENTIRE cell contents to a new sheet?
Based off the keywords in column A on SHEET ONE I want to search SHEET TWO for those keywords. The keywords will only appear once in a single cell on sheet two.* I then want to return the ENTIRE contents, not just the matching keyword, of the cell containing that keyword to column B on sheet one. I've attached an example excel file showing what I'm trying to do.
Thanks in advance for you help!
Will the keywords always be in column B of sheet 2? Can there be multiple answers?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
On the assumption that multiple results CAN occur and that the data ARE always IN Column B; try this...
Try this
=INDEX(Sheet2!$B$2:$B$18,MATCH("*"&A5&"*",Sheet2!$B$2:$B$19,0))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Formula
VBA you could use
Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you - that worked great.
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks