DCDL 600: Using VLOOKUP to Join Data from Two Separate Sources (Excel 365)

This tutorial demonstrates one technique for joining two data sets with common row identifiers. The tutorial shows how one might use the CONCAT tool to modify the FIPS identifier, and how the RIGHT formula can be used to modify another common difficult FIPS identifier so they can be matched using the VLOOKUP tool.
This tutorial is for students using the somewhat frustrating Microsoft 365 version of Excel without the standard "text-to-columns" functionality
Data Link (One Drive)
mycsunemail-my...
Accompanying Text and Lab Manual:
sites.google.c...
Music:
Complete Strangers:
• Sweet Disarray
• Don't Wanna Leave You ...