Forum Discussion
Golfnhockey12
Apr 26, 2020Copper Contributor
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.
Golfnhockey121165
Apr 27, 2020Copper Contributor
Attached is my file.
Wyn Hopkins
Apr 27, 2020MVP
Sorry, I ,meant an example of what you are trying to do
So a simple version with a brief description of what you are trying to do
Thanks
So a simple version with a brief description of what you are trying to do
Thanks
- Golfnhockey12Apr 28, 2020Copper Contributor
OK, in the attached you have in column C a description with the word sharpertek, I want a formula to search that column, find the keywords I choose and populate Column D for Vendor with in this case the company sharpertek.
- Khizar_HayatApr 28, 2020Brass Contributoryou can easily done by this find function
press control + F to open dialogue box type your word it will automatically takes to vendor columns i am sending you a pic check it- Zack BarresseApr 28, 2020Iron ContributorI don't think this is what they're looking for.
Golfnhockey12: can you clarify a bit? Where do you enter your search parameters? It's not clear what you want from your description when looking at your sample file. Please be as detailed as possible when describing what you want to do from what you have.