Excel 365 Part 12 – Lookup Functions

Lookup functions will lookup information from a database and return an answer from a different column in the database. They can be used to look up part numbers, Employee IDs, or any field that is unique in the database. If there are many duplicate Lookup Values, it will usually return the first value in the list. There is also a new function called XLookup that allows you to return the first or the last value found. Other Database functions covered that will look up and total information based on certain criteria. These Database functions work similar to the Countif, SumIF and Average If functions, but Database functions consider the entire database when it pulls information.

Video Series Part 12 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch3-sec2.mp4

- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.

Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.

Courseware: Excel 365 - Formulas, Charts, And PivotTables
The courseware is available on Amazon at: https://www.amazon.com/dp/1660221943

Section 2: Lookup Functions
The Lookup functions will lookup information from a database and return an answer from a different column. They can be used to look up part numbers, employee IDs, or any field that is unique in the database. If there are many duplicate lookup values, the Lookup Function total will usually return the first or last value. There are also new functions such as XLookup, that allows you to return the first or the last value. The following functions will be covered in the workbook: VLookup, HLookup, Lookup, Match, Index, MatchIndex, XLookup, and Offset functions.

Section 3: Database Functions
Database functions will look up and total information based on certain criteria, Database functions work similar to the CountIF, SumIF and AverageIF functions, but Database functions consider the entire database when it pulls information. The following Database functions will be covered in the workbook: DCount, DSum, DAverage, DGet, DMax, and DMin functions.
This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com