Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London
 
Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

On Site Training
Free Training Materials
Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Web design

 

If you like this site, let us create a web site for you.

Contact us for a quote.
 
 
 
Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Corporate portraits
 
Portraits for promotional material, web sites or just to decorate your office walls. See Kate's recent commissions
 
 
 
Microsoft
Office Training		 SEO & Social
Media Training		 Web Design
& SEO		 Graphic Design   Prices Client Feedback About Contact
Microsoft Office Training throughout West Sussex & East Sussex, Surrey and Hampshire: Horsham, Brighton, Burgess Hill, Chichester, Crawley, Eastbourne, East Grinstead, Haywards Heath, Lewes, Littlehampton, Dorking, Farnham, Godalming, Guildford,Redhill, Reigate, Weybridge Woking, Havant, Petersfield, Portsmouth, Southampton, Winchester, Tonbridge & Tunbridge Wells.
Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Free Microsoft Excel Tutorial - Compare Two Lists with VLookup
 

 

Microsoft Office Training > Excel Training > Free Computer Training > Compare Two Lists with VLookup

Please feel free to use this content on your web site, but please include the links at the end

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 Office Training with Blue Pecan Computer Training. Tailored Microsoft Excel Training. Microsoft Excel Training Surrey

 

 
 
Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Excel training offerings

 
Microsoft Office Courses, Microsoft Office Course Microsoft Office Training, Horsham, Brighton, Sussex, Surrey, Hampshire, London

Application resources

More free Tutorials on Tech Tutorials

 

Home |   On-site Training  |   Prices   |   Client Feedback  |   About Us |   Contact Us  | UK Photography & Sussex Photography | Sitemap
Copyright (c) 2010 Blue Pecan. All rights reserved.