LOOKUP Functions in Excel VLOOKUP, HLOOKUP, INDEX MATCH, XLOOKUP Tutorial

[@SimonSezIT]

Download the instructor files and follow along! www.simonsezit.com/excel-biz-analysis-instructor-files/

[@SleepEatWorkRepeat]

Why do none of these links work? They never send the downloads to my email.

[@victormayer5665]

the files are not available anymore...

[@dexxxxxxxx]

Links not working

[@realHAUTEcre]

I've been using Excel for over 30 years, and the presentation and syntax of this course and its content is among the best I've ever experienced. Makes diving into the Black Hole of Excel fun and interesting!

[@cliffordeaton5455]

Thank you so much for the great instructional videos. For newbies like me, they're worth their weight in gold!

[@SimonSezIT]

Glad you like them!

[@realvirtualdemand4222]

this is a great tutorial and how to get out excel skills up to par..

[@sargonkheedo]

Deb, is the best of the best... thank you Simon Sez it... this is by far the most detailed easy to learn .. thank you

[@genesisfincorp88]

It is wonder session of advance excel. learnt a lot. ❤❤

[@SimonSezIT]

Glad you think so!😊 We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@ziaglos]

Just like it. Thank you Deb 👏👏👍

[@SimonSezIT]

Glad you like it

[@justinoroy]

Thank u so much, keep doing great!

[@SimonSezIT]

Thanks for watching Justino!

[@nstcoffice3533]

Thank you for such a nice tutorial

[@SimonSezIT]

You're welcome 😊

[@jamesdep8128]

Great class. Thank you again!

[@SimonSezIT]

Thanks for watching James!🙃

[@jamesdep8128]

@@SimonSezIT I am watching all of your videos. it is greatly helping me in my training.

[@poodleseigien]

Best instructor!

[@amitpanchal135]

I am so glad mam from meet you

[@idowumayowadavid886]

Thanks so much . I just received the file for free

[@SimonSezIT]

Great! We have additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@shijogeorgethomas7830]

Perfect Explanation🙂

[@1sornram]

so freaking helpful! thanks a bunch

[@nikush1631]

Is the final module available for this online as well? Thanks for all that you do, starting a new job Monday and these videos are so helpful!

[@black90ify]

we are not receiving any e-mail to download the supported file . will you check this issue

[@bhavnakawa1299]

I have not received the support file either

[@IsingomaMugishaChristopher]

thank you ma'am

[@SimonSezIT]

You are very welcome! 😃 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@jessieren1296]

It helps a lot! Thank you so so much!

[@SimonSezIT]

You're welcome!

[@chutatipwattana399]

Thank you!!

[@SimonSezIT]

Happy to help!

[@TVSCDN]

Thanks madam🎉🎉🎉❤❤❤😊

[@SimonSezIT]

Most welcome 😊

[@lisapenfold2979]

great video. thanks.

[@SimonSezIT]

Thanks for the nice comments, Lisa 😊

[@magtulunganpinoy5597]

thanks soooooo much!!!!!

[@SimonSezIT]

No problem!

[@ianrobertson5128]

Do you do videos on Excel for Mac 365? These are fabulous but the Mac version is different in some spots.

[@SimonSezIT]

Thanks Ian, Delighted you are enjoying the tutorials and thanks for letting me know what you are looking for, we'll see what we can do: Our Excel for Mac Tutorials are currently beginner level:kzbin.info/www/bejne/qYq4ZZ5mhZ2Wa8k

[@athennasamelin425]

hii, if you don't mind, can I ask the reference you've used in Index Match (Market Research: Revenue and Profit for Popular Iphone Apps)? thank youuu

[@z-spotinternational165]

I have subscribed to the excel file already but i dun see the work file being sent - its not in the spam folder either

[@prathyushasegu4991]

HI Mam, Can you share a vedio by using Unit price inplace of Part No.

[@hestiaa9354]

I don’t know if that will work. The unit prices might be the same for several items. How would VLookup know which one to select?

[@RY-ey7dx]

For some reason, the instructor files to follow along are not accessible. the link returns a blank webpage :(

[@SimonSezIT]

Hi RY. Sorry about that. Please try clearing your cache or try another web browser.

[@RY-ey7dx]

@@SimonSezIT thanks.

[@z-spotinternational165]

the file has not gone to any SPAM Sir... hope you are able to help out with this

[@hapemokenela7388]

i didn't receive an email for the download link. Please reply.Thank You.

[@SimonSezIT]

Please check your spam folder.

[@sandhyarani362]

will u make a video on excel 2007

[@SimonSezIT]

We do have some older tutorial videos on Excel 2007. Check out this playlist ➡️kzbin.info/aero/PLzj7TwUeMQ3gIjaQf5o75BrEeaSF2cg_j

[@idowumayowadavid886]

Please I really wish to get access to the file promised in the video. I have given my email details but I am yet to receive any file.

[@idowumayowadavid886]

Thanks alot . I just received the file for free.

[@aradhyarathi2048]

Please send the document of VLOOKUP true statement for practice in my reply.

[@SimonSezIT]

You can download the instructor files for this video here: www.simonsezit.com/excel-biz-analysis-instructor-files/

[@aradhyarathi2048]

@@SimonSezIT Thank you !!

[@ememanduquincy8457]

Can you make include timestamps to such a long video?

[@SimonSezIT]

Thank you for the feedback, we'll see what we can do.

[@aydaneliyeva4682]

why doesnt work file?(

[@dexxxxxxxx]

27:26

[@dessleonid]

Nope I didn't get the result of 57 and 52 but 100 and 100 on those cells while doing your shitty match + vlookup. Why? This is BS. Why do you need this complication with match formula while just Vlookup formula manages its work pretty damn good of its own accord?