Forum Discussion
Keywords in one column to populate another
I have a file we’re in one column is have a description, I want to make a formula to look at that column for keywords which populates another column from a key.
Golfnhockey12 sharpertek, Across and Bvv is your critertia that's why your criteria word will be find in column C show as included its your target.
but right now what is your criteria?
can you tell me clearly?
And what you did worked, but instead of saying included I wanted the name of the vendor.
- True. My solution was created around my understanding of the OP's requirements. As far as I'm aware, it is a suitable solution. Haven't really heard back if it is or not though.
- when we have a complete knowledge about a problem , than it can be solved otherwise it will remain a problem.
- I'm not sure I follow. My understanding of the requirements were the OP has a list of keywords to search for (in column C) and - if found, replace the value in the Vendor field (column D) with said value, otherwise return what was already in that field.
Zack Barresse so where we can get a vendor name?
already in column D there is a vendor name present as next to the "sharpertek" so what is the criteria?
Vendors are in column D. So instead of the word included it puts the vendors name.
- Khizar_Hayat: Isn't the Vendor name in column D?
Golfnhockey12: did you try the VBA solution I posted above? - Hurry up i am waiting your response
Where is the vendor name?
- ok i am doing this, wait a minute friend
