Wildcard in vlookup | Magical Vlookup

Wildcard in vlookup | Magical Vlookup | Wildcards in excel

Рет қаралды 28,020

4 жыл бұрын

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...

Пікірлер: 40

@computorism1508 4 жыл бұрын

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.

@aniruddhadeshmukh4035 5 ай бұрын

nice explanation, thanks

@GAURAVKUMAR-rj5ep Жыл бұрын

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

@peoplespowerhellyeah8619 2 жыл бұрын

Bhalo hoye che video ta.

@abhimankhade7628 11 ай бұрын

❤very helpful

@amitapattanaik1071 3 жыл бұрын

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

@amarjeet9214 Жыл бұрын

😊

@Ashatrutube 2 жыл бұрын

Excellent concept example.. 👍🙏👍

@vlogwithyatishkandhari6293 Жыл бұрын

Very nicely explained and in detail

@lokeshdeshmukh9760 2 ай бұрын

Great

@vedantsartcraftanddrawinga4804 2 жыл бұрын

very excellant, thanks for this.

@AkshayKumar-ep5qd Жыл бұрын

Very very helpful 😊

@avinashjadhav2436 Жыл бұрын

Explanation 100%

@computorism1508 Жыл бұрын

Thank you for watching. Keep supporting :)

@pankajsaini50 3 жыл бұрын

Thank you so much ...

@computorism1508 3 жыл бұрын

Most welcome. Keep watching.

@amitapattanaik1071 3 жыл бұрын

Excellent logic

@computorism1508 3 жыл бұрын

Thank you. Keep watching

@muzammiltariq3743 2 жыл бұрын

Good Job... Thanks a lot

@computorism1508 2 жыл бұрын

Thank you for watching.

@koushikkumarroychowdhury1034 3 жыл бұрын

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

@computorism1508 3 жыл бұрын

Keep watching, there are lots of things to know

@veetchand4894 Жыл бұрын

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

@nazarkamal8831 Жыл бұрын

Very nice 👌👌👌👌

@pankajsaini50 2 жыл бұрын

Really nice 👍

@computorism1508 2 жыл бұрын

Thank you ☺️

@kaushalkuntal2814 2 жыл бұрын

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

@computorism1508 2 жыл бұрын

Thank you bro, keep watching. ☺️

@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 2 жыл бұрын

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

@computorism1508 2 жыл бұрын

Share your mail ID.

@SIVAKUMAR-fe2xg 2 жыл бұрын

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.