Forum Discussion
Solved
VLOOKUP formula - match two columns (partial) and return value
Hello there. I am facing an issue trying to match two columns and return value to third with the Vlookup formula. The idea is to do an approximate name match and get the correct value. ...
Does this work for you?
=VLOOKUP(LEFT(C8,FIND("^",SUBSTITUTE(C8," ","^",3))-1)&"*",$J$3:$K$29,2,0)
Does this work for you?
=VLOOKUP(LEFT(C8,FIND("^",SUBSTITUTE(C8," ","^",3))-1)&"*",$J$3:$K$29,2,0)