Jul 19 2021 12:17 AM
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
Jul 19 2021 12:27 AM
SolutionDoes this work for you?
=VLOOKUP(LEFT(C8,FIND("^",SUBSTITUTE(C8," ","^",3))-1)&"*",$J$3:$K$29,2,0)
Jul 19 2021 12:32 AM
@Subodh_Tiwari_sktneer, it is superb. Thank you.
Jul 19 2021 02:07 AM
You're welcome @Tom_Khachatryan! Glad it worked as desired.
Jul 20 2021 04:05 AM
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.
Jul 21 2021 07:26 PM
Jul 21 2021 08:57 PM
Jul 19 2021 12:27 AM
SolutionDoes this work for you?
=VLOOKUP(LEFT(C8,FIND("^",SUBSTITUTE(C8," ","^",3))-1)&"*",$J$3:$K$29,2,0)