# Help matching items and quantities

#### djdtex

##### New Member
I have been hunting around this forum for a while but have not found anything that works yet. I am looking for a formula to match up items in columns E and F to columns A and B. If there is not a match I would like blanks entered in column C and D if there is a match I would like E and F to be displayed in columns C and D. I am trying to sort through 5000+ lines of items to see which ones match.

Thank you.

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### Jonmo1

##### MrExcel MVP
so starting with just row 1 to understand...

IF A1 = E1 and B1 = F1 then C1=E1 and D1=F1

Is that right?

in C1 put

=IF(AND(\$A1=\$E1,\$B1=\$F1),E1,"")

Fill Right do D1,
Fill down as needed.

#### djdtex

##### New Member
That is close but let me explain it better. In the sample below if A1 has a match in column C then insert match in column B1 if there is not a match leave it blank. Your formula does work but only matches items in a particular row. I need to find out if there is a match in the whole column. In the sample below the *** stands for blanks.

444___444___320
123___***___321
124___***___324
321___321___325
322___***___326
323___***___328
324___324___444

#### Jonmo1

##### MrExcel MVP
=IF(COUNTIF(C:C,A1),A1,"")

Replies
7
Views
254
Replies
3
Views
334
Replies
8
Views
276
Replies
0
Views
150
Replies
1
Views
83

1,191,001
Messages
5,984,091
Members
439,872
Latest member
noaman79

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back