Excel and Google Sheets Tips

An Alternative to VLookup, Try Combining Index and Match in Microsoft Excel or Google Sheets. A Useful Tool for Combining Data Using a Unique Identifier.

An example of Index Match using Google Sheets
Example of Index Match in Google Sheets
Sheet 1 Employee Information
Sheet 1 Employee Information
Spreadsheet showing the cells used to add information.
Spreadsheet showing the cells used to add information.
Cells showing information
INDEX MATCH Formula with Example
INDEX MATCH Formula with Example
INDEX MATCH Formula with Example
Example with color boxes showing formula information
Example with color boxes showing formula information
Example with color boxes showing formula information
Starting sheet Example 2
Starting sheet Example 2
Starting sheet Example 2
Sheet showing the formula without absolute values
Sheet showing the formula without absolute values
Sheet showing the formula without absolute values
GIF showing result of formula with $ Absolute value
GIF showing result of formula with $ Absolute value
GIF showing result of formula with $ Absolute value
Sheet showing the formula with boxes.
Sheet showing the formula with boxes.
Sheet showing the formula with boxes.

Learning through teaching technology.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store