Microsoft Excel Index And Match Search Function Tutorial

Quick tutorial on how to use Microsoft excel index and match search function to get information from a dataset, table or range.

Also, we looked at the Microsoft random function (“=randbetween”) to generate dummy data used for our analysis.

These functions (index & Match combined) can be used in searching for values in a table quickly where functions like the Vlookup & Hlookup fails due to their limitations.

If you find this video helpful, kindly like, subscribe and share for more videos like this. Also, comment so I can improve better as I’m currently working on my voiceover videos. Thank you!




.
.
.
.

Follow on my socials via:

Instagram: @acetech.mov
LinkedIn: @ in/owhofasa-emrobowasan






#setup #computeraccessories #dualmonitorsetup #dualmonitor #microphone #tutorial #data #monitor #dataanalysis #dataanalytics