Hi,
I'm trying to come up with a formula in which I can auto-populate a cost code into a column by searching for keywords in another column. A separate worksheet would contain all the descriptions and cost codes as reference for the search. The problem I'm having is that the data I'm searching through will have extra words and characters which are irrelevant to me, so it's not an exact match, and some of the descriptions fall under the same cost code. I just need to keep focus on the keywords in my description. I will then need to replicate that formula on multiple worksheets in the workbook and repeat the process on thousands of workbooks. I'm going to end up writing a macro to make the process more efficient but need to start with the basics first. Any help and/or suggestions would be appreciated.
I'll attach a sample because it's just easier to see it than for me to poorly explain it haha.
Bookmarks