Matching data in columns

[Robt]

Hi,

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

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

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

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

 

[Claus Busch]

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