Lookup Functions & Table Relationships

Guide for Understanding Lookup Functions and Table Relationships in Excel.

One of the most important concepts in Excel is understanding how to relate data together. This opens up an additional level of analysis that is not available without understanding these concepts. Please click the button below labeled download guide for a free copy of this guide.

Lookup Functions

Excel Contains many different functions and methos for looking up and relating data together. The Ten methods included in this guide are:

1. VLOOKUP

2. HLOOKUP

3. Index-Match-Match

4. Offset-Match-Match

5. LOOKUP

6. DGET

7. XLOOKUP

8. Table Relationships in Excel

9. Power Query

10. Power Pivot Table Relationships

The first seven items in the guide are Excel functions and the last three are non-function methods for relating data together.

I recommend anyone wanting to really learn Excel take the time to learn the different methods for lookup and relating data together in Excel. This will open up many advanced concepts and tools for conducting deep analysis and creating beautiful dashboards and data models with tools such as Power Query, Power Pivot and Power BI.

Over the coming weeks I will provide a blog on each of the different methods and provide some of the best resources for learning each of these concepts on the web. We will start with VLOOKUP.

As a brief preview I have listed three great blogs and videos on the web for learning more about VLOOKUP below

1. How to use the Excel VLOOKUP function | Exceljet

2. The last guide to VLOOKUP in Excel you'll ever need (updated) (spreadsheeto.com)

3. 10 VLOOKUP Examples For Beginner & Advanced Users (trumpexcel.com)

A couple great videos include

1. Jon Acampora at Excel Campus provides a great video on VLOOKUP, how to use it, common errors, and more.

2. This is a video that covers both VLOOKUP and HLOOKUP and is by Leila Gharani.

3. The third and final video in this blog is by Mike Girvin at Excel is Fun and is a comprehensive guide with over 1 hour of instruction and training on the VLOOKUP function.

Stay tuned for more blogs in this series about lookup functions and relating data in Excel. Look forward to your comments on this blog series below.