Okay, this is my first time asking a question in excel in 25 years. I've been able to figure out everything else.
I've got data coming in from a bank feed. I want to look for key words in the description and match it with a table I have on a separate tab and get the xlookup result. For instance, if a cell contains the text "bcb" anywhere in it, I want it to look up bcb on the table and return "blue cross." In this way I'm mapping BCBS and BCBSF (each rows in that table) to blue cross.
Any ideas? The current process is memorizing all the possible codings and typing them into a manual field and having it look it up for me. There's often a string of numbers and letters before were the key words appear and it varies in length.
I've got data coming in from a bank feed. I want to look for key words in the description and match it with a table I have on a separate tab and get the xlookup result. For instance, if a cell contains the text "bcb" anywhere in it, I want it to look up bcb on the table and return "blue cross." In this way I'm mapping BCBS and BCBSF (each rows in that table) to blue cross.
Any ideas? The current process is memorizing all the possible codings and typing them into a manual field and having it look it up for me. There's often a string of numbers and letters before were the key words appear and it varies in length.