I have one excel spread sheet with sheet1 and sheet2, they both only have
columnA,

on sheet1 as following:




on sheet2 as following:





so sheet2 has , sheet1 does not have this.
so how to write the macro match this two sheet1 and sheet2 columnA and have
result show up on sheet1

thanks
Lillian