Help matching items and quantities

[djdtex]

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.

 

[Jonmo1]

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]

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

Thanks for your help.

 

[Jonmo1]

=IF(COUNTIF(C:C,A1),A1,"")