Matching data in columns
 

Hi,

I only have a basic understanding of Excel and have a problem that I'm hoping someone will be able to help with.

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.

If someone could please help I would really appreciate it. I'll probably need a step by step idiots guide if possible please!

Matching data in columns
 

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