Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formula

Resolved · Low Priority · Version 2002/XP

Reply Thu 12 Mar 2009, 14:12Delegate Sarah said...

Sarah has attended:
Excel Intermediate course

Formula

Have you got a formula for comparing two lists of values?

For upcoming training course dates see: Pricing & availability

Reply Fri 13 Mar 2009, 08:57Trainer Cress said...

RE: Formula

Hello Sarah
Thank you for your question

This depends on how you are trying to compare them, but you could try VLOOKUP. Highlight the first list and name it as range 1, ensuring that the first column is the column you want to compare. Then use the vlookup formula to see if values in your list are present in your other list.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Thu 19 Mar 2009: Automatically marked as resolved.

Excel articles

· Find Out Your Age In Days With Excel
· Microsoft Excel Training - Numerical excellence for all
· How To Use Excel To Track Your Weight Loss
· Microsoft Office and the Small Business: Part 1 Excel
· How To Make Excel Open A Particular File When It Launches

Please browse our web site to find out more about
excel vba training and other Microsoft training courses.

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips