[FREE Excel Course] Lesson 12 - Lookup and Reference Formulas in Excel

[@redherring4119]

Would be nice if you could add time tags to your long videos to make it easier for us to come back and review parts that we didn't quite understand the first time.

[@Sunnyyskr]

Sir,this is the best free excel course in youtube.Your presentation skills are top notch.Thank you so much sir🙏 and if possible can you share pdf of this course with us.

[@redhaal-obaidy2217]

Mostly used is the Vlookup and a mixture of Match and Index is very helpful, Anyway, since I have big data spreadsheets, I benefitted of Column and Columns. Thank you so much for such impressive infromation!

[@ArkanToS182]

Thank you for all of the excellent free content, Summit Bansal. Greetings from Brazil!

[@ellisiverdavid7978]

Some functions seem absurd and funny, especially the INDIRECT function. It feels like when someone wants to tell you about something, but that someone delays or avoids telling you the main point for some reason? Like reading between the lines or solving a riddle? Too much beating around the bush. 😂 Anyway, thank you again for the superb explanations, Mr. Sumit. Looking forward to seeing the applications of these functions in the coming videos. Stay safe!

[@Irfan-27564]

Sumit Bhai your excel video is very useful for me. I learned so many things.

[@trumpexcel]

Thank you for the kind words Irfan... Happy to know the videos have been helpful 🙂

[@sesham075b4]

great videos sir, small suggestion can u give some examples liked why these are used in excel. mainly like match, offset etc

[@vishupandey7008]

Thank you so much for making these.

[@trumpexcel]

Glad you're finding the videos useful

[@GoGetSP]

With the explanation given above, couldn't understand the INDIRECT function. Anyway thanks for this video =)

[@thanhtun6432]

Thank a lot for your valuable lessons

[@utube_snakeu553]

Thanks a lot for these amazing lessons. These are really useful :)

[@highflierpriyanka]

your way of explanation is awesome

[@MuhammadSohaib-qm6iw]

Very nice summit, thanks again for these awesome videos 😊

[@vishnusoman8532]

Very informative Thanks, brother

[@israelgodinho6027]

Why does he hit Ctrl+Enter instead of Enter? I never get it

[@fayazmuhammad5983]

When we work with array formula then press ctrl+enter instead of just press enter key.

[@RavinderSingh-ix6gt]

very important class of excel

[@Hi-yi3vj]

Thanks for the upload

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@GurjeetSingh-de6xd]

If you use more data for V&H lookup then it will be understandable how to use.

[@congratz9396]

Great video! Very informative

[@jimbim1623]

He supports Trump, how do you feel about that

[@drtusharprabhakar5684]

This video is not uptomark... observation in this video, Lack of knowledge in V'lookup & H'lookup etc.. now im little bit confused, that all your execl tutorial are in proper manner or lack of knowledge in excel...

[@himi1509]

Thanks Sir

[@sambhavjain1915]

good video ...... but can any one tell me that weather we have to learn these formulas from lesson 11 to lesson 15 ? as i am new

[@jyotisharma9313]

Useful video...Thankyou

[@aniketbhosale3171]

Good video.... But Why do we need this formulas? As I m new I don't know

[@congratz9396]

They are tools to make things more efficient in large and various types of datasets - for instance, what would take 2-4 people to do manually without these formulas you could do all by yourself (depending on the dataset complexity ofcourse which increases your ability to be efficient).

[@PayalKewlani-i8p]

I am unable to understand what happened in the last part of INDEX function

[@bholaincanada8547]

when i used vlookup in which i used text as a look up value,but the rank of my very first cell was higher than the rank of lookup value.Does it means that the vlookup value in case of text do not need the text should be arranged in ascending order?

[@Rahul-bz2bu]

why you don't put 14 in double Quotes for approximate match

[@Amocles]

When using =INDIRECT("C"&C25) I don't get any values, it's like the ampersand isn't working. Any idea why? =INDIRECT("C26") gives me the value of C26.

[@umamaheshk6151]

i too didn't get any value, same problem here

[@ellisiverdavid7978]

Mine worked perfectly. What's in your C25? I have some spare time now; I can help you troubleshoot your work.

[@binduskumar3201]

It didn't worked for me too...

[@richardlevine5163]

@@ellisiverdavid7978 I agree, you have to see, what is in C25

[@minervasarma6785]

how do I hit F9 for multiple columns to convert formula into value, when there is a #VALUE error?

[@buttheadrulesagain]

Remember for any formula, instead of putting actual values, you can input a cel, so you can create a table where you can input quickly different values and the formula automatically outputs the result of the formula.

[@KimFrancesBamba]

so many ungrateful ppl in this comment section lol no one is forcing you to watch these videos ^-^ be nice or keep it to yourself

[@muskangarg3832]

=vlookup("t",A3:C5,3,1) is giving the corresponding value to tom but. Also first example of vlookup is not working. If you could answer please.

[@Tech4Geeky]

some functions are useless bz it changes its value so y the video is so long, pnly VLOOKUP,INDEX,MATCHis usefull

[@umamaheshk6151]

sir here MATCH is good only when the data is sorted? if the data is not sorted then there will be some error, is it right? or wrong?

[@ashwindeshmukh4525]

YES

[@umamaheshk6151]

@@ashwindeshmukh4525 if the data is not sorted then the command is not useful sir.....

[@m-sgaming1441]

Where we use VLOOKUP HLOOKUP WTF !!

[@Shoulderdevil2023]

The first Vlook up I couldn't get to work in Google Sheet or Apple Numbers-OOF

[@gautamkumarjaisal6170]

Sir अगर ये कोर्सेज हिंदी में बनाए तो हम जान सके क्योंकि अँग्रेज़ी भाषा हमें बहुत ही कम समझ में आती है....

[@m-sgaming1441]

Where we use these formulas???😢

[@bodygaber6069]

Idk butt i think it's for blind ppl .

[@congratz9396]

In large and various types of datasets. They are tools to make things more efficient - for instance, what would take 2-4 people to do manually without these formulas you can do all by yourself (depending on the dataset complexity ofcourse).

[@nilukumari8084]

Jab hame pata hi hoga ki wo data kahan hai coloumn and row no then hum q use karege.bas formula remember kar ke explain kar diya real life use to bataya hi nahi

[@rajvideocreations]

16:00

[@gautamkumarjaisal6170]

पूरे वीडियो के

[@ClassyGamerX]

Areee Hindi mai video bana detaaaaa

[@yashkulshrestha4931]

This one was reallly long and boring, ngl

[@mr.gamingplays3827]

try to make your videos more entertaining

[@ashishmanusma6011]

plz try to explain in simple way dont make the things complex.

[@mr.gamingplays3827]

i swear he makes his videos way too long and i dont like but thank you anyway -

[@jimbim1623]

make it 1.5 x