I am trying to do a search for specific text within a column. If it is found, I need it to populate the adjacent cell with a predetermined value. For example if "VendorA" is found anywhere in A2, B2 needs to read VendorA. I have as many as 30 unique vendors. Is there a way to make a list of all vendors and look for matches? Thanks in advance.
Last edited by BrettW; 10-14-2013 at 04:31 PM.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Sorry about that. I assumed the Search function would be the solution somehow and was hoping by titling it "Search" it would help to point someone in the right direction. I have edited it as requested.
Please Login or Register to view this content.
Jarko, thanks for your help. I should have been more clear in my explanation. Cell A2 may contain something like "VendBobsFoundryand Machine ToolingInc". The desired output in B2 would be "Bobs Foundry". I am importing a text file and often times the spacing is inconsistent. The message box you created would not find or create "Bobs Foundry" since there is no space between the s and the F in the original string. I need it to function so that anytime column A has the word Bob in it column B will output Bobs Foundry. I could put Bob into the message box you created, but then my output would be only Bob, not Bobs Foundry. Thanks.
Hi,
This code will look at all entries called "bob" within the imported list and say "Bob's Foundry" if you typed in Bob
say you typed in "mark", then it will say "Mark's warehouse"...
is that what you need? i guess I'm not clear on what you are trying to achieve...
Please Login or Register to view this content.
Works great Jarko. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks