Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London
 
 
 
  tel: 0800 612 4105 email: info@bluepecan.co.uk  

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

List 1

List 2

Compare

A

M

G

K

J

J

I

Q

U

U

B

X

V

Z

D

P

 

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

 

   
   

 

 

 

 

Copyright (c) 2012 Blue Pecan. All rights reserved. Sitemap