Sort and Match Uneven Columns of data

[MustardMan]

I have an spreadsheet with many rows of data. Columns A and B are a set of results from a phone bank; columns C, D and E are results from another phone bank. I need match column B (and its corresponding data in Column A) with Column C (and its corresponding data in Column D and E). Note: I have read similar posts in this forum and other places on the web, but the proposed solutions, for whatever reason, do not seem to work. Here is an example (I have also attached the file)

Copy of Dial Download 10 22 12_B.jpg
Copy of Dial Download 10 22 12_B.xlsx

[vlady]

if you find the match what will it do return column A? then sort that.

[MustardMan]

I am sorry, but I do not understand your reply.

[vlady]

You will match B and C right, then if they have a match what will it do next.

Col B Col C

123 111
456 123
789 456

[MustardMan]

I need the data in the rows of columns A & B to align with columns C, D and E, matching the phone numbers in B and C. Here is an example of how I want the final results to look.
A B C D E
Called Supposed to be not called
dial_disposition Dialed_phone Dialed_phone dial_disposition
ANSWER 5302183886 5302183886 Voice Message Left
ANSWER 5302315274 5302315274 Voice Message Left
ANSWER 5302315449 5302315449 ANSWER Not Interested
ANSWER 5302315679 5302315679 ANSWER Do Not Call

[vlady]

ok, can't upload your file try the formula below referenced to your file,if this is what you want.

in G3 =IFERROR(INDEX(A:A,MATCH(H3,C:C,0)),"")
in H3 =B3
in I3 =IF(COUNTIF(C:C,H3)>0,H3,"")
in J3 =IFERROR(INDEX(D:D,MATCH(H3,C:C,0)),"")
in K3 =IFERROR(IF(INDEX(E:E,MATCH(H3,C:C,0))=0,"",INDEX(E:E,MATCH(H3,C:C,0))),"")

***change the ranges to appropriate one eg. from Index(A:A) to Index(A3:A1000)

[MustardMan]

That worked! Thank you so very much!