VLOOKUP with Wildcards

VLOOKUP with Wildcards - How to use

Рет қаралды 16,045

Жыл бұрын

Sometimes the data is so mixed that VLOOKUP doesn't work. Because lookup value is not clearly readable, applying simple VLOOKUP formula won't help.
This is where we use VLOOKUP with wildcards to perform partial text match to find our return value even if our lookup value is not easily readable from lookup column.
In this Excel video tutorial, we are learning how to use wildcard characters like asterisk to perform partial match lookup using VLOOKUP formula. So follow along in this step by step tutorial to understand how easy it is!
Access or Download Practice Workbook for this tutorial:
1drv.ms/x/s!Apno7889bCyLrAorQ...
Lets Excel!
For more Excel tips, tricks and tutorials don't forget to subscribe to ‪@LearnExceltoexcel‬ YT channel.
Learn #Excel your way:
===================
Website: learnexceltoexcel.com/
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#excelvlookup #vlookupwildcard #vlookuppartialmatch #exceltutorial #exceltips

Пікірлер: 15

@misbahraj8015 Жыл бұрын

Superb

@iftikharahmad015 10 ай бұрын

Thank you

@sharemarket200 9 ай бұрын

Great

@juderoseaccountancy Жыл бұрын

Great tip- thank you

@LearnExceltoexcel Жыл бұрын

Hi5!!!!

@mos3863 Ай бұрын

Can you explain it what have you done in that formula

@johnlaunchillegotardo3992 Жыл бұрын

Is it possible to use as an alternative, the index & match function for this? Thank you in advance for your help.

@LearnExceltoexcel Жыл бұрын

Yes very much possible. Almost the same concept

@johnlaunchillegotardo3992 Жыл бұрын

@@LearnExceltoexcel Thank you. :)

@abirulhoquechy9480 Жыл бұрын

How to split mixed data?

@LearnExceltoexcel Жыл бұрын

That's a question for another tutorial! But ask away whatever you have in mind and I will try to answer here

@johansanjaya3891 Ай бұрын

@@LearnExceltoexcelwe can use text to column right?or split with power query

@prasoonraj6651 Жыл бұрын

What did that * do??

@LearnExceltoexcel Жыл бұрын

Asterisk or * denotes that we can have multiple characters. As we have asterisk both left and right, we told Excel's VLOOKUP that there are multiple characters to the left and right of "lookup value". VLOOKUP then did a partial match and found the return value for us even with appended and trailing text

@prasoonraj6651 Жыл бұрын

@@LearnExceltoexcel Thnks