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 ...
Hi,
VLOOKUP doesn't help in this situation, you need to a special formula like this:
=INDEX($F$2:$F$7,MATCH(TRUE,INDEX(ISNUMBER(SEARCH($E$2:$E$7,A2)),),0))
Regards