Тёмный

Excel VLOOKUP Formula Exact Match video tutorial 

MyOnlineTrainingHub
Подписаться 655 тыс.
Просмотров 134 тыс.
50% 1

Watch this video to learn how to create a VLOOKUP Exact Match Formula in Excel. Click here for step by step written instructions: www.myonlinetr...
View my comprehensive courses: www.myonlinetr...
Connect with me on LinkedIn: / myndatreacy

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

 

28 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 20   
@rachidt7636
@rachidt7636 3 года назад
Thank you very much, please to share the excel sheet data used
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Follow the link to the step by step written instructions in the video description. On that page you'll find the link to download the workbook.
@Mohsen_1968gholipour
@Mohsen_1968gholipour 10 месяцев назад
Thank you so much for this video . What should be done if the data is duplicated? Thank you for your reply
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 месяцев назад
It depends on how you want to handle it. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@andriuszelvys7800
@andriuszelvys7800 3 года назад
Hi, I encountered a problem with vlookup, I have values similar to these: "A*123" and "A*B-123", so if I look up for "A*123" and it is not present in the lookup table, it finds "A*B-123" any workarounds besides removing "*" sign to find exact value?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Prefix the asterisk with a tilde in the lookup i.e. =VLOOKUP("A~*123",...)
@beoramargolis4565
@beoramargolis4565 Год назад
Thank you so much for this video. It was so easy to follow and NOW I understand vlookup thanks to you . Please continue to add - Absolutely a pleasure watching and listening to you
@MyOnlineTrainingHub
@MyOnlineTrainingHub Год назад
Thanks for your kind words!
@ursdeepu707
@ursdeepu707 3 года назад
Hello Could you please help me with this formula I have 2 sets of data In Column A I have list of 50k user names In column B I have 5k usernames I’m sure that all the column B usernames will present in a Column A list but want to make sure there is no miss matches in names, means the name should be in same way like no difference in lower case and upper case, name should match exactly in column A and column B Thank you 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 3 года назад
Hi Sandeep, I would use Power Query to compare the two lists as it is case sensitive, unlike most Excel functions: www.myonlinetraininghub.com/excel-compare-two-lists
@ursdeepu707
@ursdeepu707 3 года назад
@@MyOnlineTrainingHub thankyou!!
@arturoguzman5230
@arturoguzman5230 4 года назад
Wow long time ago 😍
@Ndofi
@Ndofi 6 лет назад
Thanks for your interesting classing. They are making office life super:)
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 лет назад
:-) glad I can help, Ndofi.
@thenick_316
@thenick_316 11 лет назад
awesome! saved my day. thank you!
@jobalert3838
@jobalert3838 4 года назад
Hi mam thanks really for providing such a nice tutorial
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 года назад
My pleasure, Akhil!
@jobalert3838
@jobalert3838 4 года назад
@@MyOnlineTrainingHub Hi Mynda mam Thankyou. Mynda mam i m learning excel from you.
@jobalert3838
@jobalert3838 4 года назад
Thankks Mynda mam. Happy Teachers Day to you mynda Maam
Далее
How to Use VLOOKUP to Compare Two Lists
15:20
Просмотров 824 тыс.
Advanced Excel - VLOOKUP Basics
11:58
Просмотров 2,2 млн
"Когти льва" Анатолий МАЛЕЦ
53:01
Самая сложная маска…
00:32
Просмотров 1,2 млн
Compare Two Lists Using the VLOOKUP Formula
12:49
Просмотров 2,9 млн
Excel: Combining Vlookup and Match Functions
8:30
Просмотров 92 тыс.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Vlookup Function in Excel for Beginners
11:35
Просмотров 1,7 млн
VLOOKUP Exact Match Formula in Tamil
9:09
Просмотров 1,6 тыс.
How To Use Index Match As An Alternative To Vlookup
19:28
How to Use Excel XLOOKUP and XMATCH Functions
10:36
Просмотров 53 тыс.
How to Use VLOOKUP in Excel (free file included)
15:15
Просмотров 234 тыс.
"Когти льва" Анатолий МАЛЕЦ
53:01