Hi Zocor;

I'm not for sure about the java. For the ID's you can use
something like this;



Sub try()

Range("A2").select
While Not activecell = ""

If activecell = activecell.offset(0,2) then

'copy the address
MyAddress = activecell.offset(0,3)
'right here go put it where you want it
' and then return to the active cell

end if

activecell.offset(1,0).select



End Sub


Thanks,

Greg



-----Original Message-----
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


.