Need formula or macro

  • Thread starter Thread starter Theo
  • Start date Start date
T

Theo

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
 
Hi Teo,

One way:

Name the ColumnA:B data on Shet2 as Table.

In B2 on Sheet1 enter the formula:


=IF(NOT(ISERROR(VLOOKUP(A1,table,2,0))),VLOOKUP(A1,table,2,0),"")

Drag the formula down as far as needed
in column B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

matching multiple columns on different worksheets 1
How do Excel define the application area? 3
Index match with multiple criteria(different than usual) 3
macro to hide columns and/or worksheets 4
Copying the last used cell only 4
Query to Return Value from Seperate Worksheet 2
Using cell value to reference another cell 2
Slow code when used as VBA code instead of macro (copying visible columns) 3

Back
Top