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.
Khizar_Hayat: Isn't the Vendor name in column D?
Golfnhockey12: did you try the VBA solution I posted above?
Golfnhockey12: did you try the VBA solution I posted above?
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?
- 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.