Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • Contact

vlookup

  • Home
  •   »  
  • vlookup
Excel
xlookup vs. index and match

XLOOKUP vs. INDEX & MATCH

The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.

Excel Training Videos
compare two lists video

How to Compare Lists in Excel (Video)

In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but

Excel Training Videos
index and match excel

How to Use Index & Match (Video)

INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place

Excel Training Videos
Index Match in Excel

How to Use Vlookup (Video)

Vlookup is a very useful function for looking up data from a table, comparing two lists, matching data sets, and much more!

Excel Functions Excel Lookup and Reference Functions
XLOOKUP – Excel Function

XLOOKUP – Excel Function

What it does: The XLOOKUP() Function allows you to look up and return values in corresponding columns or rows (!!). I have an

Excel
top things to know in Excel

Top 5 Things to Know in Excel

I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how

Excel
Index Match in Excel

How to use INDEX and MATCH together

I’d probably list INDEX-MATCH in the top 5 things to know in excel if you want to add the skill to your resume and not

Excel Functions Excel Lookup and Reference Functions
INDEX – Excel Function

INDEX – Excel Function

What it does: THE INDEX() Function returns a value based on the array of values you select and the row and column within that

  • Articles
  • Excel Training Videos
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com