Тёмный

VLOOKUP Exact Match with  

Show and Tell Training
Подписаться 745
Просмотров 282 тыс.
50% 1

In this video, we will use the VLOOKUP function in Excel and look for an Exact match in a table found on a separate worksheet. We'll also fix several #N/A errors that appear...
showandtelltraining.com

Хобби

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

 

8 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 61   
@LeighRay
@LeighRay 6 лет назад
After watching several videos on VLOOKUP this was the first that cut right to the chase. And the bonus here was a plain-speak demo on fixing those inevitable #N/A errors. THANK YOU Show & Tell Training!
@stephaniebosquet879
@stephaniebosquet879 2 года назад
So simple and it worked - spent forever searching for a solution. Thank you!
@lonepeakgeek
@lonepeakgeek 8 лет назад
GAAA! I had blank spaces trailing the data in one of my cells. Your tutorial helped me figure that out and fix it. THANK YOU VERY MUCH!
@TheManincognito
@TheManincognito 5 лет назад
Perhaps the first vdo showing both vloopuk usage along with NA fix after watching dozens of vlookup vdos.. So much relief ! Thanks
@AncaFitness
@AncaFitness 3 года назад
Very useful..... Nice way of showing the possible errors.. Thanks
@ibrahimlabbo6228
@ibrahimlabbo6228 5 лет назад
THANK YOU FOR THIS GREAT JOB, I REALY LEARN VERY MUCH
@RohitGupta-ob9xx
@RohitGupta-ob9xx 6 лет назад
Thank you so much your video very helpful to me.
@VanishCreativeworks
@VanishCreativeworks Год назад
Best explanation ever no one cleared this doubt thankyou so much
@aathvik1903
@aathvik1903 7 лет назад
thank you very much your video helps me to find out the error
@AshaGovind7
@AshaGovind7 4 года назад
Really helpful! Thank you!
@Stillkicking24
@Stillkicking24 6 лет назад
Thank you. This really helped.
@withnasir
@withnasir Год назад
It worked for me after trying many other solutions. Thanks.
@bpankajapatel2148
@bpankajapatel2148 7 лет назад
Thank u, simple way to remove N/A.
@PurplePillers
@PurplePillers 2 года назад
That absolute value method did the trick for me. I must’ve watched 20 videos on how to fix this dumb thing. Thankfully I came across yours!!!
@marymwangi2154
@marymwangi2154 2 года назад
Such a helpful video!! Solved my today's problems. Asante sana! from Kenya
@krishnapatel3140
@krishnapatel3140 Год назад
It's working. Thank you.👍👍
@zahraasalman2811
@zahraasalman2811 3 месяца назад
Many thanks , I lost about 1 hour to find the answer in other videos
@vishwanathiari
@vishwanathiari 3 года назад
Thank you saved a lot of time and headache
@bruush491
@bruush491 Год назад
Wow thank you you're really a life savior 🥰
@VITS-bp7fc
@VITS-bp7fc 2 года назад
Simply awesome it worked thank you 😊
@anandakumarsabbithi5881
@anandakumarsabbithi5881 2 года назад
Thank you.. Its working
@guruprasadgattikar772
@guruprasadgattikar772 4 года назад
Awesome trick....it helped me a lot resolve the issue
@sourabhsingh9300
@sourabhsingh9300 4 года назад
Thank you so much.helped me a lot
@getloct
@getloct 2 года назад
Thanks, helped solve the issue
@inderjitchaugule
@inderjitchaugule 5 лет назад
THANKS ALOT HELPED ME ALOT
@MrChamankumar
@MrChamankumar 6 лет назад
Thanks.....................finally it is working
@Su_Desh
@Su_Desh 2 года назад
You really helped me 🙏
@syedmuzzammil9130
@syedmuzzammil9130 2 года назад
Thanks a lot 😌 you it worked....!!!
@sagarchudasama7791
@sagarchudasama7791 5 лет назад
Thank you, Thank you, Thank you so much sir........
@MandsaurAshishkumar
@MandsaurAshishkumar 3 года назад
thank You Sir......................GOOD work , its realy workes
@dwinesmonte6292
@dwinesmonte6292 2 года назад
Simple & Brief.. Worked
@madhursurve
@madhursurve 5 лет назад
Thanks for informative video...
@marigoldg2111
@marigoldg2111 3 года назад
Thank you! So "a space" was causing my problem.
@subhodeep5400
@subhodeep5400 4 года назад
It works. Thanks a lot.
@vanessachen2330
@vanessachen2330 5 лет назад
Thanks for you help.
@soniamittal4130
@soniamittal4130 Год назад
Thank u sir.. it hels me alots
@hirudas1073
@hirudas1073 Год назад
Thank you very much
@denijazz10
@denijazz10 2 года назад
Thank you !
@manigandanperumal1205
@manigandanperumal1205 5 лет назад
Thanks dear it's working
@streamsound2870
@streamsound2870 2 года назад
ကျေးဇူးပါ ခင်ဗျာ
@arifadam905
@arifadam905 5 лет назад
thank you for your lesson, it very help.
@lesegommasechabamapena7403
@lesegommasechabamapena7403 4 года назад
Thank you so much
@NeerajKumarcdc
@NeerajKumarcdc 6 лет назад
Thanks a Lot ... :)
@deepchowdhury3623
@deepchowdhury3623 3 года назад
Thanks a ton
@AshishPatel-wd3wm
@AshishPatel-wd3wm 4 года назад
I love you I don it thank you so much sir
@teresamwaura4940
@teresamwaura4940 2 года назад
Very helpful
@putnanjappar7913
@putnanjappar7913 3 года назад
Thank you
@ms24845
@ms24845 Год назад
Thanks to u.
@chiragsarkar5992
@chiragsarkar5992 3 года назад
Thanks bro
@chiragjain7236
@chiragjain7236 5 лет назад
i am matching number but still #N/A Errors show, there no "white Space" in call
@09shirish
@09shirish 4 года назад
Thanks for your valuable guidance, Sir my problem in vlookup() command is like this.... In my product ID is 1.01 .......1.100 it cannot be selected my product, if you can solve my problem i'll be highly oblige ! thanks !
@prashantrathore7451
@prashantrathore7451 3 года назад
Thanks
@Anikvikram
@Anikvikram 3 года назад
Nice
@rameshwarprasad8752
@rameshwarprasad8752 2 года назад
While applying VLOOKUP finally same formula getting paste in result cell...what is solution
@SirNyukuriEdwin
@SirNyukuriEdwin 4 года назад
The IF and SUMIF functions in excel: @
@devendrashukla537
@devendrashukla537 Год назад
Why it show error
@NJHeart2Heart
@NJHeart2Heart 2 года назад
NA# corrections start at 2:18
@vladimirmarkovic516
@vladimirmarkovic516 7 лет назад
thanks!
@MohammedAnzar-os7dp
@MohammedAnzar-os7dp Год назад
sir koi simal trike se samja ho ganta kuch samj nhi aara
@7oa178
@7oa178 4 года назад
Thank you so much
Далее
Dealing with the #N/A error in Excel VLOOKUPs
9:31
Просмотров 82 тыс.
How to use Excel Index Match (the right way)
11:32
Просмотров 3,6 млн
best way out of the labyrinth🌀🗝️🔝
00:17
Why My Vlookup Function Does Not Work?
6:04
Просмотров 173 тыс.
7 Ways to Use Vlookup in Excel
16:44
Просмотров 2,7 млн
Advanced Excel - VLOOKUP Basics
11:58
Просмотров 2,1 млн
MS Excel - Vlookup in Excel Video Tutorials
6:38
Просмотров 10 млн
Compare Two Lists Using the VLOOKUP Formula
12:49
Просмотров 2,9 млн
Excel VLOOKUP With Multiple Workbooks
12:14
Просмотров 3,4 млн
Мамы двухлеток, вы тут? 🤪
0:10
Просмотров 1,8 млн
Быстрые листья для голубцов
0:36
Greenhouse watermelon pest control process
0:11
Просмотров 5 млн
ЗДОРОВАТЬСЯ НЕ УЧИЛИ… или?
0:14