Forum Discussion
Vlookup formula - partial text search
Hi, 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 ...
The formula in B2 of the attached file, copied down rows, is:
=LOOKUP(2,
1/(ISNUMBER(SEARCH(E$2:E$7,A2))),
F$2:F$7)