View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
theo theo is offline
external usenet poster
 
Posts: 66
Default Need formula or macro

Thank you VERY much.
T

"Theo" wrote:

I've looked and can't find help on this task.....

I have e-mail addresses in column A of worksheet1. They can be duplicated.
I have unique e-mail addresses in column A of worksheet2. In column B of
worksheet 2 I have a variable called Method.

In column B of worksheet1, I want to match the e-mail from worksheet1/A to
worksheet2/A and return that e-mails Method. If there is no match, it can be
left blank, or be "None".

If someone could point me to sample code, that would be great.
Thanks