Comparing Lists in Excel

Comparing Lists in Excel -
Many people try to use Excel as a database. One of the common tasks in a database is joining tables so that you can get a field from one list (i.e. the sales rep name associated with a sales rep number) and add it to another list. To match lists in Excel, you need to use VLOOKUP functions. I recently discussed the ins and outs of using VLOOKUP on TechTV's Call for Help. For details on using VLOOKUP, read Comparing Lists in Excel.