Microsoft Office Training >Tips and Tricks

Compare Two Lists with VLookup

This tutorial will allow you to examine two lists to see which values in list 2 appear in list 1.

1. In a new worksheet enter the following lists starting in A1

2.  Name List 1 list_1

3. In C2 type =VLOOKUP(B2,list_1,1,FALSE)
The lookup looks up the value in B2 in list 1 and returns #NA when there is no match or a letter when it appears in both lists.

Microsoft Excel Training with Blue Pecan Computer Training. Tailored Microsoft Excel Training Surrey