MS Excel - 7 reasons for

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

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

50% 1

Check out our 19.3 hrs. Full Excel Course in Hindi - bit.ly/3hGGsPg
Learn Vlookup formula in Excel
• Excel VLookup Formula ...
Learn Index + Match Formula in Excel
• Index + Match formula ...
0:00 Introduction to 7 reasons for #N/A error in VLOOKUP
0:54 $ is missing in the table array
2:47 Not careful when using inter-sheet reference for table array
3:56 Numbers are formatted as text - Use VALUE, T2C, ISNUMBER
6:39 Extra spaces - Use TRIM, LEN
7:25 TRUE vs FALSE - False if not a slab
8:54 Lookup value not in the leftmost column of the table array - INDEX MATCH
9:53 Formula Calculation Options - Manual vs Automatic
7️⃣ reasons for #N/A error in VLOOKUP | Excel in Hindi
#vlookuperror #excellookup #excelinhindi
To watch more videos visit: www.excelsuperstar.org/
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar
Subscribe to the Channel: / excelsuperstar

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

14 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

Комментарии : 133

@spokenenglishworld1650 Месяц назад

for me, 6th reason worked and thank you so much.

@AJ-nm9gb Год назад

thank you so much, none of the other youtubers mentioned the last point . i was trying to solve this error from 6 hours ....! finally...!

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

Superb video sir, i always had an problem of text to column but you sort it out....thanks

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

Very helpful videos, thanks for uploading. Hoping for many more ...

@hrushikeshsahoo886 3 месяца назад

Really you are great sir 🙏🏼. I was unable to find the error from my side but after watching your video now the issue is fixed. Thanks again . Keep the amazing ahead 👍🏼

@akshayp3655 Год назад

You made it really easy man, don't know why less likes to ur video. It's one of the most helpful video regarding Vlookup function errors on RU-vid.

@kristinearellano2864 Месяц назад

because his title is english but the language he used is not english

@Sivakumar.Annadurai 5 месяцев назад

Life saving tips! Thanks.

@satyajitchatterjee3713 Год назад

Great video Bhaiya, Iss se accha video, itni acchi tarah se smjhaya hain aap, bohut accha, bohut help hua... channel subscribe Karne PE majboor ho geye humm...Thanks

@GyanPani Год назад

One of best videos on #N/A Errors... Very well explained brother..

@mahnoorahmad2667 Месяц назад

THANK YOU SO MUCH!!! I was stuck on it for hours, I had the 6th error.

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

Thanks bhae. Maine sach me sar pkda hua tha but u have sorted things for me.

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

Your video was truly helpful for me.

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

Maan gye guru ji bahut badi problem solve kr diye

@user-vn8uk6te7d 9 месяцев назад

YOU ARE AMAZING I TRY COUPLE OF TIME BUT THE WAY TO TEACH ITS AWESOME

@uzmajaveed3251 Год назад

God bless you baai ❤️...i had literally stuck .. Thankyou

@soumenghosal4066 Год назад

Thank you so much its very good & easy to understand

@mictesting012 3 месяца назад

excellent, worth saving this video

@kavitaverma9929 Год назад

Thank you!! first error se hi mera lookup thik ho gya

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

बहुत बहुत धन्यवाद सर

@chandaachebonge4688 Год назад

Thank you for the solution

@SnehaaPrabhu 2 месяца назад

bro,you're a genius....thanks mannnn

@manjit.sarania Год назад

All video are amazing sir

@LakshyaRaj9127 Год назад

Vai tumhara idea Kam Kar gaya. ThnQ vai

@mukeshsinghhthakurr4725 Год назад

🙏Thanks a lot sir.....2 din se pareshan tha....#N/A error se.....Mera problem reason 1 category vala tha

@sanuswarnkar5176 Год назад

-1 formula worked for me . Thankyou sir

@vinayakpotadar4093 11 месяцев назад

Super sir my question is slove for this best video. Thank u sir

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

Bhai aapki video ka bht intazaar kiya

@manjit.sarania Год назад

Thanks for good information sir

@mdasharashraf6322 Год назад

1st reason , ab clear hi gya bro

@auromitabasu4020 Год назад

Don't know how to thank you. I faced the last problem.. I spend a whole day to solve the problem but failed. After finding several video I found your's!! Thank you sooo much, tou save my day..

@faizansheikh9602 7 месяцев назад

Thank you sir it's working 👌🏻👌🏻👍👍😊😊🥰🥰

@sarojvinod8282 Год назад

Bahoot badiya sir

@WORLDINFOPEDIA-fv1he Год назад

Very Helpful video

@MrBamalesh Год назад

Thank you. I was looking 3 solutions

@syedwaqas8304 Месяц назад

great work, problem solved.

@kamranabbasi2510 Год назад

after watching this video I found the solution. Thankyou so much

@Ttimesnewsno1 Год назад

you are a real superstar of excel

@PritamPaul717 9 месяцев назад

Thanks a lot sir ❤️👌😊

@vinayrai18 Год назад

Thanks sir solution mil gya

@saifrashid6713 4 месяца назад

Thankyou so much brother. '

@Dhananjayjadhavs 10 месяцев назад

Perfect video for query

@pankajshukla2404 Год назад

Thank u very much sir ji

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

Take love from Bangladesh,🇧🇩❣️

@quaidbhai-lt8ho Год назад

VERY GOOD JOB SIR

@devmaurya5903 Год назад

Thanks a lot

@nithyaraj1919 Месяц назад

Too informative sir

@satinathmaity1664 9 месяцев назад

It is so helpful

@spiritualrealm5891 Год назад

magician.. thank u

@anilvmc1597 Год назад

Thank you sir

@praveendixit1161 Год назад

THANX SIR THANX A LOT

@dilopunjabi8891 Год назад

Grt. Mine problem is sorted.

@rokgite Год назад

Thanks 👍👍👍

@vinayrai18 Год назад

Very nice helpful

@nirmalverma7746 2 месяца назад

After watching this video, I found solution. Thank you.

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

Thank you Sir.

@manash3s Год назад

Thanks ...

@arghyahalder2042 Год назад

Very good video

@amipolymer716 Год назад

Thank , solved

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

Superb ❤️ 🙏Plz make word tutorial in Hindi Like the ones you made at the Yoda Learning Academy

@sandeshshet5787 Год назад

Thank you so much😊

@LalitKumar-nj7xc 2 года назад

Thank you for making my life easy.

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

keep watching

@Rani-mt1ep Месяц назад

Thanks

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

Amazing 🤩

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

i fixed my N/a problem , issue was leftest column , thanks !!

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

Very informative bhai... Would like to learn more...

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

Keep watching

@amarnath_85 Год назад

Thank you sir I am searching for this problem "Text to number" Thank you

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

Tanks sir ji

@tirupathirayudupasupuleti6573 Год назад

4th one is very helpful

@TravelAdventure-India 2 года назад

It was good Sir

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

He'll sir, make video on SQL please sir

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

Plz sir SQL

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

Yes sir take SQL tutorial 🙏🏻🙏🏻🙏🏻

@bnsbuzzz2911 Год назад

Needful stuff

@rahulgarg8520 Год назад

this video was so helpful. Almost browsed so many videos but finally got the issue of #NA.. thanks team

@MumtazAhmad-fx3pg 2 года назад

sir superb information❤❤😘😘

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

Keep watching

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

Thanks sir earlier I was in a misconception that I m master in Vlookup concepts, but I know new things in ur video. Thanks

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

Happy to help

@rajsoni-ch7sb Год назад

Ooh

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

@@ExcelSuperstarlink kaha h Data slab related vlookup of your video

@TayyabAli-ef7jj 5 месяцев назад

Good bro love you 8 ghunty sy me Pagal ho gya tha aik video dahikhi Kam bun gya hahah

@NikhilKumar-wy4wk 2 года назад

Superb❣️

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

Thanks 🤗

@codegen2.O Год назад

👌

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

Gud evening sir.

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

Happy new year

@PradeepKumar-mg9bk 2 года назад

Here is a real content which is demand

@Manishkumar-ty3ke 2 года назад

Nice video

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

Thanks

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

Thank you sir, actually my look up value are left hand side

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

Use Index function and column number in minus

@aminulislam-nw5rg 8 месяцев назад

❤

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

जय जोहार

@theopenstack Год назад

Love 💕 u 😘

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

Please guide how to use vlookp with filtered data

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

sir mere saath bhi aisa huwa hai, trimbhi kya fir bhi nahi ho raha pls help

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

Number stored as text troubled me, I multiply with 1

@Ahmed00233 4 месяца назад

I received Exact Match but with the error of an inconsistent formula Does one have the solution?

@gjcsitaphalmandi-gz6lo Год назад

sir Error is showing when dragged to right side right side column is not getting extracted

@user-di4rx3qc9w Месяц назад

on my system while xlookup working properly on his system at same file. # value error is showing on my system

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

i have other reason that above metntioned..all are above factors are OK in my case..then too showing error

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

Sir how to remove SPILL Error?

@neharawat6340 Год назад

Vlook up formula also give error when data is not available in table Array.that kind of N/A how can we remove

@krishanpalsingh3093 Год назад

Mera to first row me hi value baki me N/A aaya vlookup lagane pr.aisa kyo?

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

I m facing one more problem, some time data is available in the cells but doesn't come by Vlook up...means that if data is not on the same rows of column then doesn't come