Wildcard in vlookup | Magical Vlookup | Wildcards in excel

Подписаться 2 тыс.

Просмотров 29 тыс.

50% 1

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

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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.

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

@vlogwithyatishkandhari6293 Год назад

Very nicely explained and in detail

@amitapattanaik1071 3 года назад

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

@aniruddhadeshmukh4035 8 месяцев назад

nice explanation, thanks

@AkshayKumar-ep5qd Год назад

Very very helpful 😊

@Ashatrutube 3 года назад

Excellent concept example.. 👍🙏👍

@vedantsartcraftanddrawinga4804 3 года назад

very excellant, thanks for this.

@abhimankhade7628 Год назад

❤very helpful

@avinashjadhav2436 2 года назад

Explanation 100%

@computorism1508 2 года назад

Thank you for watching. Keep supporting :)

@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

@kalpeshpanchal7411 2 года назад

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

@lokeshdeshmukh9760 5 месяцев назад

Great

@nazarkamal8831 2 года назад

Very nice 👌👌👌👌

@muzammiltariq3743 3 года назад

Good Job... Thanks a lot

@computorism1508 3 года назад

Thank you for watching.

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