Search Excel Macro Help!

Tags:
Excel macros
Microsoft Excel
VBA
Visual Basic for Applications
I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.
ASKED: November 28, 2008  3:24 PM
UPDATED: March 17, 2009  6:38 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

No need to know scripting. Excel 2007 has many built-in functions to help out.
A few questions: 1) Are the words sorted? 2) Do you need exact match & the closest match?
Suppose Col B has the words (row 5 thru 100) & Col C row 5 you want the word to appear.
On C5 type: =VLOOKUP(“search word”,B5:B100,1,FALSE)
Or try on C5: = INDEX(B5:B100,MATCH(“search word”,B5:B100,0),1)

Good luck

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Findsarfaraz
    if you need to see example on VLOOKUP you can visit this link http://findsarfaraz.blogspot.com/2009/03/vlookup-function-to-find-if-value-is.html Regards, Sarfaraz Ahmed
    1,395 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following