hello again and thank u all for your replies...sorry for not posting the sample tables. Please see below for your reference (could not find where to attach file or image). In table one the column "email address" is created by me, where I would like to see email addresses from table 2, with the criteria that the names of the company and the addresses in 2 tables should be same.
Table1:
<TABLE border=0 cellSpacing=0 cellPadding=0 width=358><COLGROUP><COL style="WIDTH: 75pt" width=100><COL style="WIDTH: 104pt" width=138><COL style="WIDTH: 90pt" width=120><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="WIDTH: 75pt; HEIGHT: 15pt" class=xl65 height=20 width=100>Name</TD><TD style="BORDER-LEFT: medium none; WIDTH: 104pt" class=xl65 width=138>address</TD><TD style="BORDER-LEFT: medium none; WIDTH: 90pt" class=xl65 width=120>email address</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl64 height=20>COMPANY1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64>SYDNEY</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl64 height=20>COMPANY1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64>PERTH</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl64 height=20>COMPANY2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64>MELBOURNE</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl64 height=20>COMPANY3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64>HOBART</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl64 height=20>COMPANY4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64>BRISBANE</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl64></TD></TR></TBODY></TABLE>
Table2:
<TABLE border=0 cellSpacing=0 cellPadding=0 width=298><COLGROUP><COL style="WIDTH: 59pt" width=79><COL style="WIDTH: 68pt" width=91><COL style="WIDTH: 96pt" width=128><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="WIDTH: 59pt; HEIGHT: 15pt" class=xl67 height=20 width=79>name</TD><TD style="BORDER-LEFT: medium none; WIDTH: 68pt" class=xl67 width=91>address</TD><TD style="BORDER-LEFT: medium none; WIDTH: 96pt" class=xl67 width=128>email address</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl65 height=20>Company1</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl65>Sydney</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl66>
test@yahoo.com</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl65 height=20>Company2</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl65>Melbourne</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl66>
ggg@hotmail.com</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl65 height=20>Company3</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl65>Hobart</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl66>
mmm@test.com</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt; BORDER-TOP: medium none" class=xl65 height=20>Company4</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl65>Brisbane</TD><TD style="BORDER-LEFT: medium none; BORDER-TOP: medium none" class=xl66>
jut@aaanet.com</TD></TR></TBODY></TABLE>