RE: Comparing a list of values

Subject: RE: Comparing a list of values
From: "Turner, Katherine" <kturner -at- Metastorm -dot- com>
To: "A.H." <isaac840 -at- yahoo -dot- com>, <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Mon, 26 Mar 2007 09:10:14 +0100

Hi Anthony,

Vlookups are a very good way of comparing two lists.

A few tips:
* Make sure you name your range, for example if you're looking up a
value in A3:A49, name the range something relevant, alternatively you
need to make sure that you make you range absolute ie $A$3:$A:$49.

* Sort the lists

* Take a look at Vlookup in help and remember to specify TRUE=closest
match, FALSE=exact match if required.

I hope this is helpful.

Kind regards,

Katherine Turner
Technical Author
The opinions expressed are strictly my
own and not necessarily those of
my employer's.

-----Original Message-----
From: A.H.
Sent: 23 March 2007 16:53
To: techwr-l -at- lists -dot- techwr-l -dot- com
Subject: Comparing a list of values

I've got an Excel doc with two worksheets: one with a list of (225)
forms and associated URLs and another with new (275) forms.

I need to compare them and output the difference.
Does anyone know a way to do this?

I think in the past I used a vlookup but I can't get it to work.

Anthony Hernandez

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.



Create HTML or Microsoft Word content and convert to Help file formats or
printed documentation. Features include single source authoring, team authoring,
Web-based technology, and PDF output.

Now shipping: Help &amp; Manual 4 with RoboHelp(r) import! New editor,
full Unicode support. Create help files, web-based help and PDF in up
to 106 languages with Help &amp; Manual:

You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit

To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit for more resources and info.

Previous by Author: RE: MS Word: Figures 1-3 or Figure 1, Figure 2, and Figure 3
Next by Author: RE: Old PC Technology (too long, sorry)
Previous by Thread: Re: Comparing a list of values
Next by Thread: OT: Friday funnies ... the medieval help desk

What this post helpful? Share it with friends and colleagues:

Sponsored Ads

Sponsored Ads