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)
Subodh_Tiwari_sktneer, it is superb. Thank you.
You're welcome Tom_Khachatryan! Glad it worked as desired.
Hello Subodh_Tiwari_sktneer , I tried the same formula in another sheet, but still getting the same error. I can not understand the core of this issue.
- Please pay attention to the lookup value in the formula, the values in lookup_column in the table_array must start with the lookup value.