Matching Column Data

[tindercd]

I need to match up two exports from our system to create one spreadsheet. I'm having trouble matching two columns up and placing the end result into a new column. I'm trying to use IF AND functions but that approach may be the wrong one.

I'm currently using this formula in the B column:

=IF(AND($C$2:$C$17333=A2,$D$2:$D$17333=15),A2&"-"&15,"N/A")

This is an example of the spreadsheet. I'm using Excel 2007

A	B	C	D
4		4	1
6		4	12
16		4	15
17		6	1
19		6	15
20		16	1
21		16	15

<tbody>
</tbody>

My question is what formula could I use to get the end result in the B column that will read 4-15, 6-15, 17-15 etc.

Thanks!

 

[texasalynn]

try this

Excel 2010
	A	B	C	D	E
1	4		4	1	N/A
2	6		4	12	N/A
3	16		4	15	4-15
4	17		6	1	N/A
5	19		6	15	6-15
6	20		16	1	N/A
7	21		16	15	16-15
Sheet1

Cell Formulas
Range	Formula
E1	=IF(AND(SUMPRODUCT(--($A$1:A1=C1)),D1=15),C1&"-"&15,"N/A")