RE: Comparing a list of values

["Turner, Katherine" <kturner -at- Metastorm -dot- com>]

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


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.  

Thanks,
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. http://www.DocToHelp.com/TechwrlList

Now shipping: Help & 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 & Manual: http://www.helpandmanual.com

---
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 http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


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
http://www.techwr-l.com/techwhirl/ for more resources and info.