Wildcard in vlookup | Magical Vlookup | Wildcards in excel

In this video you can learn how to use wildcards in vlookup in excel.
Index , Match and Vlookup formula to lookup values from 4 different tables - • Index , Match and Vloo...
Data sorting by column - • How to sort data by co...
Multilevel subtotal - • How to apply multiple ...
Extract text from cell - • Extract text from cell...
Dget function - • DGET function excel in...
Sum - • AUTOSUM FUNCTION IN EX...
Average - • How to use Average fun...
Concatenate - • CONCATENATE FUNCTION i...
Count, CountA & Countblank - • COUNT, COUNTA & COUNTB...
If (Part1) - • If function in excel I...
If (Part2) - • NESTED IF FUNCTION IN ...
All Shortcuts - • Sum Function, Average ...
Len - • LEN function in excel ...
Rand & Randbetween - • Rand & Randbetween Fun...
Countif - • Video
Countifs - • Video
Sumif - • Video
Sumifs - • Video
Text Function - • Text formula in excel ...
Iferror - • IFERROR FUNCTION IN EX...
Index Function - • Index Function in Exce...
Match Function - • Match function in exce...
Index + Match Function - • Index Match function i...
Vlookup - • Vlookup in excel , vlo...

[@computorism1508]

In case of Question Mark Wildcard, a question mark will represent a character. Here these 2 question marks are representing those 2 characters ("WB", "BH", "OD" Etc) which we have in the bill numbers.

[@amitapattanaik1071]

Very good explanation, good logic to extract, best of luck

[@Ashatrutube]

Excellent concept example.. 👍🙏👍

[@aniruddhadeshmukh4035]

nice explanation, thanks

[@GAURAVKUMAR-rj5ep]

you are great sir your all videos are very important, you have very exelent knowledge of ms office

[@vlogwithyatishkandhari6293]

Very nicely explained and in detail

[@vedantsartcraftanddrawinga4804]

very excellant, thanks for this.

[@peoplespowerhellyeah8619]

Bhalo hoye che video ta.

[@abhimankhade7628]

❤very helpful

[@AkshayKumar-ep5qd]

Very very helpful 😊

[@lokeshdeshmukh9760]

Great

[@amarjeet9214]

😊

[@muzammiltariq3743]

Good Job... Thanks a lot

[@computorism1508]

Thank you for watching.

[@koushikkumarroychowdhury1034]

Excellent usually such tricks are available in books available in the market

[@computorism1508]

Keep watching, there are lots of things to know

[@avinashjadhav2436]

Explanation 100%

[@computorism1508]

Thank you for watching. Keep supporting :)

[@amitapattanaik1071]

Excellent logic

[@computorism1508]

Thank you. Keep watching

[@pankajsaini50]

Thank you so much ...

[@computorism1508]

Most welcome. Keep watching.

[@nazarkamal8831]

Very nice 👌👌👌👌

[@kaushalkuntal2814]

WHAT A EXPLAINATION , IT'S MIND BOBBLING. THANKYOU BRO

[@computorism1508]

Thank you bro, keep watching. ☺️

[@pankajsaini50]

Really nice 👍

[@computorism1508]

Thank you ☺️

[@veetchand4894]

You can use "Left or Right" in lookup if the look up has same number of digits

[@kalpeshpanchal7411]

But words aur sub kuch ekjitna hoga tohi wild card use hoga bill no ke case me .8 9 lag laga row me data hoga to kaise hoga ?? Mark se please explain

[@tinkuroy6392]

Sir I need that file
Sir your data explanation is super 👍👍👍👍

[@computorism1508]

Share your mail ID.

[@SIVAKUMAR-fe2xg]

Sir iam looking formula...
Where i have data starts ABL , ABLT,DBL, XLNTC, T1243,123G, 24CL,
Out of these we want any thing starts with ABL it should print ABL, if starts with ABLT it should print ABLT, if starts with DBL it shoul print DBL, if it starts with T it should print as TILT, remaing it should be blank.
Please note the text length is variable , it may start with number, alphabet.
Please suggest formula.

[@sdsbma]

plz share this file for practice

[@Eidulazhatales]

Undo karna hay ya Aaandoo??

[@computorism1508]

KUCH BHI KARLO APKO JO PASAND AAYE 😄

[@calculationiseasy5854]

sir i have to need this file

[@computorism1508]

Drop your mail ID

[@calculationiseasy5854]

@@computorism1508 [e-mail]

[@mutlunun]

Ear destroying but useful video. Watch on mute 😉

[@computorism1508]

Will try to rectify the issuses & thank you for watching,.. :)