conditional vlookup, duplicates, blank cells

  • Thread starter Thread starter cathal
  • Start date Start date
C

cathal

I have two worksheets that I want to compare - 1 worksheet has 650 emai
addresses, worksheet 2 has 10000 email addresses,with adjacent column
having postal address details. However, many of the email addresses o
worksheet 2 are duplicates, and only one or two e-mail addresses o
perhaps a dozen duplicate entries has address details.

My question: how can I combine VLOOKUP with IF to ensure that if
common e-mail address is located, that if adjacent columns are blan
then to continue until an address in a column adjactent to the e-mai
column is found? I want the postal address to be entered in workshee
1, corresponding to the postal addresses as per the e-mail address i
worksheet 2.

I am using a forumula of the type

=IF(J2=" "," ",VLOOKUP(BD2,array,column,FALSE))

However, I note that if I use VLOOKUP alone I return identical results
Furthermore, deleting 'postal address' cells corresponding to th
appropriate e-mail address (save
for one) does not 'pull' the postal address into worksheet 1. In othe
words, the formula I have used does not function accurately.

Can anyone suggest a way that would work?

thanks, cathal.
 
-----Original Message-----
I have two worksheets that I want to compare - 1 worksheet has 650 email
addresses, worksheet 2 has 10000 email addresses,with adjacent columns
having postal address details. However, many of the email addresses on
worksheet 2 are duplicates, and only one or two e-mail addresses of
perhaps a dozen duplicate entries has address details.

My question: how can I combine VLOOKUP with IF to ensure that if a
common e-mail address is located, that if adjacent columns are blank
then to continue until an address in a column adjactent to the e-mail
column is found? I want the postal address to be entered in worksheet
1, corresponding to the postal addresses as per the e- mail address in
worksheet 2.

I am using a forumula of the type

=IF(J2=" "," ",VLOOKUP(BD2,array,column,FALSE))

However, I note that if I use VLOOKUP alone I return identical results.
Furthermore, deleting 'postal address' cells corresponding to the
appropriate e-mail address (save
for one) does not 'pull' the postal address into worksheet 1. In other
words, the formula I have used does not function accurately.

Can anyone suggest a way that would work?

thanks, cathal..
Click to expand...
 
Cathal,

From what I can see, you need to re-sort your data in
worksheet 2 so that the postal addresses are found first.

Vlookup will return the first occurrence of a match to
the criteria specified. ie. BD2 in array

So what you need to do is put your postal address first.

to do this sort Worksheet 2 by email address, ascending
and postal address descending.

steve
 
Back
Top