VLOOKUP, MATCH AND INDEX MATCH - MS EXCEL INTERMEDIATE

VLOOKUP Function
VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.
FORMULA
=VLOOKUP(lookup_value,table_array, col_index_num, [range_lookup])
VALUE - The value to look for in the first column of a table.
TABLE - The table from which to retrieve a value.
COL_INDEX_NUM - The column in the table from which to retrieve a value.
RANGE_LOOKUP - [optional] TRUE = approximate match (default). FALSE = exact match.
SEARCH
ID Number First Name Last Name Email Address Department
567 Holly Holm hh@hh.com OPD
1 2 3 4 5
ID Num First Name Last name Email Address Department
123 Joe Rogan jr@gmail.com HR
234 Brendan Schaub br@aol.com Purchasing
345 Ronda Rousey rr@yahoo.com Med Admin
456 Manny Pacquiao mp@hotmail.com OR
567 Holly Holm hh@hh.com OPD
MATCH FUNCTION
The basic MATCH function returns a NUMBER based on the relative position of a lookup value within a defined array / column.  
FORMULA
=MATCH(lookup value, lookup array, match type)
LookUpValue RESULT
Pacquiao 4
INDEX FUNCTION
=INDEX(array,MATCH formula )
LookUp Value Index Match
Last Name ID Num
Pacquiao 456
Rousey  
   
=INDEX ( Column I want a return value from , MATCH ( My Lookup Value , Column I want to Lookup against , Enter “0” ))
VLOOKUP to a different Sheet
Formula
=VLOOKUP(A2,Sheet1!F10:G20,2,FALSE)