Welcome to our platform, Reza Akbar. The VLOOKUP-TRUE argument is mainly used when we work with numeric data. TRUE, as the last argument of the VLOOKUP function, will return an approximate match of the lookup value. In your demonstration, I recommend you to go for the exact match, in this case, FALSE. I am implementing a method to resolve your issue using an exact match in the VLOOKUP function. Hopefully, the procedure will be completable with a large dataset.vlookup with true didn't solve the problem, i dont know how big is the data, it just small example my problem
Hello Reza Akbar,i have problem with vlookup because they use abbreviation
the data that i get it use abbreviation and the source that i get it it don't use abbreviation
The formula is responsible for removing the abbreviation.=TRIM(RIGHT(SUBSTITUTE($E$14," ",REPT(" ",LEN($E$14))),(LEN($E$14)-LEN(SUBSTITUTE($E$14," ","")))*LEN($E$14)))
=VLOOKUP("*"&$C$12,$G$2:$I$10,1,FALSE)
=VLOOKUP("*"&TRIM(RIGHT(SUBSTITUTE($E$12," ",REPT(" ",LEN($E$12))),(LEN($E$12)-LEN(SUBSTITUTE($E$12," ","")))*LEN($E$12))),$G$2:$I$10,1,FALSE)
Great to hear that the solution worked perfectly and you understand the mechanism of the formulas, Reza Akbar! The VLOOKUP function can work with an Asterisk (*) as a wildcard character in the lookup value. We can use the Asterisk (*) sign at the lookup value's beginning, middle, or end or in combination with other characters to create more complex search patterns.vlookup work with Asterisk (*)? how its work??
edited:
i see, that how its work,
asterik also work with middle name