2021 - Using VLOOKUP, INDEX and MATCH Functions

Learn the arguments in the VLOOKUP function
Understand the importance of absolute references within many lookup functions
Use VLOOKUP to perform approximate matches
Use VLOOKUP to look up data from another workbook
Learn how VLOOKUP stops looking after it finds an initial match within a list
Explore why VLOOKUP sometimes returns #N/A
Learn about the IFNA to explain #N/A
See how the HLOOKUP function enables you to perform horizontal matches
Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
Use the MATCH function to find the position of an item on a list