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.
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.
when we have a complete knowledge about a problem , than it can be solved otherwise it will remain a problem.
- 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.