Hi

Two Questions:

1. Does Excel Support Java?

2. I have a spreadsheet as follows:

id name id address
01 bob 02 12 street...
02 sam 03 14 street...

want it to be

id name address
01 bob null
02 sam 12 street

So, is there a way for Excel to compare id in column 1 with id in column 3,
and for every match extract the address, if no match put a null for address.


Thanks in advance
ZOCOR



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/2004