Tip:
Highlight text to annotate it
X
VLOOKUP: Everything You Need to Know for Excel Success
Square brackets mean that argument is optional
lookup value - what to lookup
table array - where do you want to look
column index number - column to return value
VLOOKUP - Vertical HLOOKUP - Horizontal
Excel 2013
VLOOKUP will work in all versions of Excel
Undo is Ctrl + Z on the keyboard
Duplicates will be ignored and the first value found will be returned. There ARE workarounds though!
References are relative (vs. absolute, no dollar signs)
Contextual ribbon tabs only show when those items are selected
When the table is de-selected the ribbon tab hides
Red highlighted values show what is returned Yellow highlighted values show what is desired
This menu is from right-clicking the mouse
If no exact match is found it will return the #N/A error
Sort in ascending order for approximate lookups
Cols: =tblData5[#Headers]