I am trying to use the Vlookup formula to search by Keywords in a cell and bring the value for category.
I have the following example, on the first column I have the debits (long text with a lot of information). I want to search by the Keyword and bring the category to the second column.
Someone can help?
VLOOKUP doesn't help in this situation, you need to a special formula like this:
The formula in B2 of the attached file, copied down rows, is: