Hi,

Am Thu, 28 Mar 2013 14:54:53 +0000 schrieb Robt:

I have a spreadsheet which currently has 4 columns. Column 1 is a series
of purchase order numbers, and column 2 is a list of email addresses
associated with those orders. There are 219 rows or entries in both
columns.

In column 3 I have the purchase order numbers again and in column 4 I
have a list of first names associated with those orders. The problem is
that in columns 3 & 4 I only have a total of 155 entries or rows. So I
need to find a way of grouping columns 3 & 4 and then matching them to
column 1 so that the names match the corresponding email addresses and
that there are blank cells where there should be.

your data in Sheet1. Then copy columns A:B and paste it to a new sheet.
Then in C1 of the new sheet:
=IF(COUNTIF(Sheet1!$C$1:$C$300,A1)=0,"",VLOOKUP(A1 ,Sheet1!$A$1:$D$300,4,0))
and copy down.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2