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.
Will appreciate your help.
Thank you
Does this work for you?
=VLOOKUP(LEFT(C8,FIND("^",SUBSTITUTE(C8," ","^",3))-1)&"*",$J$3:$K$29,2,0)
6 Replies
- In your Vlookup formula, you are using 0 as the last argument which is used for an exact match. Use 1 instead as you want to do an approximate match.
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.
