Index and Match Functions With Drop Down Lists | Excel

This excel video tutorial provides a basic introduction into the index and match function with drop down lists which is an effective combination for retrieving data from a database.
Excel Tutorial For Beginners: • Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
________________________________________
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
Excel Vlookup Function:
• How To Use The VlookUp...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
Multiple Dependent Drop Down Lists:
• How To Create Multiple...
How To Show & Hide Formulas:
• How To Show and Hide F...
______________________________________
Relative & Absolute Cell References:
• How To Use Relative & ...
Lock Cells and Protect Sheets In Excel:
• How To Lock Individual...
Excel Interactive Checklist:
• Interactive Checklist ...
Excel Pivot Tables:
• Intro to Pivot Tables,...
______________________________________
TH-cam Channel Growth Accelerator:
/ youtubechannelgrowthac...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections

[@wilbergomez6217]

EXACTLY WHAT I NEEDED, THANK YOU!

[@12InchesUnBuffed]

great vid, been looking for this for past 30 mins

[@SilentEagle2029]

Wow, you even have excel tutorials. Your reach has no end, I love it! lol

[@vijaykandasamy]

Very useful. Thank you.

[@HuyTChea]

Thanks! it was very useful.

[@sampada.07]

You saved me today. Thank you very much.

[@HowIsEveryHandleTakenAlready]

Thank you so much, after searching for a solution for a half an hour, this is the only tut that I really understood and that helped me, well done!

[@davidsweeney111]

nice tut, very useful, can you do a few vids on MS Access database setup and use pls, cheers!

[@maryjoybaco]

Thank you so much.

[@TIE-TakeItEasy]

I used to go away from English videos. But when I watched this one, I think my perception was
wrong. Wow..... I can get everything very well. Thanks!

[@Captain_Prize]

thank you bro

[@wongpeggy4363]

love it

[@10MEDRADO]

Thank you!

[@wongpeggy4363]

Hi used already super good, but how come some time it will hand the whole workbooks and exit itself

[@johnwalker-cx6rc]

Can you do this with a drop down list for two items such as name and date of birth? How would you do that?

[@chrissee6826]

Great video... I have a question I made something similar on some of the customer ID that I type
#N/A shows up on the name.. help please

[@wongpeggy4363]

how to solve? inside this workbook i have others worksheet which link to payment summary/payment voucher/ cash book

[@wongpeggy4363]

hi may I have the code it is very useful to my payment summary link to payment voucher

[@wongpeggy4363]

please