MS Excel - 7 reasons for

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

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

[@mohitgangele5528]

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

[@mahnoorahmad2667]

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

[@Sivakumar.Annadurai]

Life saving tips! Thanks.

[@hrushikeshsahoo886]

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 👍🏼

[@ansariirfan3473]

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

[@GyanPani]

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

[@anmolhariharno7259]

Maan gye guru ji bahut badi problem solve kr diye

[@uzmajaveed3251]

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

[@shridharsharma7280]

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

[@tariqnaseem3528]

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

[@chandaachebonge4688]

Thank you for the solution

[@Ttimesnewsno1]

you are a real superstar of excel

[@mukeshsinghhthakurr4725]

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

[@user-vn8uk6te7d]

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

[@mdasharashraf6322]

1st reason , ab clear hi gya bro

[@LakshyaRaj9127]

Vai tumhara idea Kam Kar gaya. ThnQ vai

[@kavitaverma9929]

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

[@shreyapalodhi5786]

Your video was truly helpful for me.

[@sarojvinod8282]

Bahoot badiya sir

[@manjit.sarania]

Thanks for good information sir

[@Dhananjayjadhavs]

Perfect video for query

[@devmaurya5903]

Thanks a lot

[@kamranabbasi2510]

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

[@vinayrai18]

Thanks sir solution mil gya

[@SnehaaPrabhu]

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

[@sanuswarnkar5176]

-1 formula worked for me . Thankyou sir

[@soumenghosal4066]

Thank you so much its very good & easy to understand

[@manjit.sarania]

All video are amazing sir

[@rokgite]

Thanks 👍👍👍

[@WORLDINFOPEDIA-fv1he]

Very Helpful video

[@mictesting012]

excellent, worth saving this video

[@manash3s]

Thanks ...

[@gayanmadushanka4330]

Thank you Sir.

[@anilvmc1597]

Thank you sir

[@Rani-mt1ep]

Thanks

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

[@asimshahzad5696]

Bhai aapki video ka bht intazaar kiya

[@vinayakpotadar4093]

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

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

[@kristinearellano2864]

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

[@MrBamalesh]

Thank you. I was looking 3 solutions

[@dilopunjabi8891]

Grt. Mine problem is sorted.

[@spiritualrealm5891]

magician.. thank u

[@sandeshshet5787]

Thank you so much😊

[@faizansheikh9602]

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

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

[@pankajshukla2404]

Thank u very much sir ji

[@praveendixit1161]

THANX SIR THANX A LOT

[@satinathmaity1664]

It is so helpful

[@PritamPaul717]

Thanks a lot sir ❤️👌😊

[@quaidbhai-lt8ho]

VERY GOOD JOB SIR

[@saifrashid6713]

Thankyou so much brother.
'

[@nirmalverma7746]

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

[@enamdotul7112]

Take love from Bangladesh,🇧🇩❣️

[@arghyahalder2042]

Very good video

[@amipolymer716]

Thank , solved

[@ifthiqar3422]

Amazing 🤩

[@nithyaraj1919]

Too informative sir

[@rashid8879]

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

[@vinayrai18]

Very nice helpful

[@syedwaqas8304]

great work, problem solved.

[@amarnath_85]

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

[@tirupathirayudupasupuleti6573]

4th one is very helpful

[@naveengurjar7855]

Tanks sir ji

[@TravelAdventure-India]

It was good Sir

[@nirupammishra7434]

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

[@bnsbuzzz2911]

Needful stuff

[@LalitKumar-nj7xc]

Thank you for making my life easy.

[@ExcelSuperstar]

keep watching

[@rahulgarg8520]

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

[@varsharana9112]

Gud evening sir.

[@Fab2Mc]

Happy new year

[@MumtazAhmad-fx3pg]

sir superb information❤❤😘😘

[@ExcelSuperstar]

Keep watching

[@theescanor8985]

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

[@ExcelSuperstar]

Keep watching

[@NikhilKumar-wy4wk]

Superb❣️

[@ExcelSuperstar]

Thanks 🤗

[@manishmandal3942]

He'll sir, make video on SQL please sir

[@manuu8444]

Plz sir SQL

[@abhishektiwari2643]

Yes sir take SQL tutorial 🙏🏻🙏🏻🙏🏻

[@TayyabAli-ef7jj]

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

[@PradeepKumar-mg9bk]

Here is a real content which is demand

[@Manishkumar-ty3ke]

Nice video

[@ExcelSuperstar]

Thanks

[@pradeepjangid490]

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]

Happy to help

[@rajsoni-ch7sb]

Ooh

[@umeshchandraverma6518]

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

[@naveengarg526]

Please guide how to use vlookp with filtered data

[@hiradharsahu7019]

जय जोहार

[@codegen2.O]

👌

[@tusharsharma744]

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

[@Chinus]

Use Index function and column number in minus

[@prashantlende1311]

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

[@theopenstack]

Love 💕 u 😘

[@ansariirfan3473]

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

[@aminulislam-nw5rg]

❤

[@vinodpaneliya]

Sir how to remove SPILL Error?

[@subhashdhoke8439]

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

[@canirmalchoudhary8173]

Number stored as text troubled me, I multiply with 1

[@joshuajohnson9672]

While applying vlookup, after scrolling down to fetch Data same data are copied

[@dotNet6]

6

[@Ahmed00233]

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

[@Satyendra2022]

𝗧𝗵𝗮𝗻𝗸❤🌹🙏 𝘆𝗼𝘂💯💯 𝗦𝗶𝗿

[@gjcsitaphalmandi-gz6lo]

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

[@joshuajohnson9672]

Facing one error while using vlookup formals

[@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?

[@user-di4rx3qc9w]

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