Find Matching Data Two Columns

[Gilly]

I have data that I am pasting into columns A and B. C is an empty column.
I have existing data in columns D, E, and F. I would like to find the
common data in columns B and D, and add the matching data to empty Col C
plus bring along all associated data from other columns.

For Example:

Pasted Data Cols A - B Existing
Data Cols D - F


Col A = BDAY | B = NAME | C= EMPTY | D = NAME | E = AGE | F =
AREA-CODE

5th Jim B
Scot C 22 413
18th Ron J
Ted F 31 615
21st Scot C
Jim B 45 213


AFTER SORTING:


Col A = BDAY | B = NAME | C= EMPTY | D = NAME | E = AGE | F =
AREA-CODE

5th Jim B Jim B
Jim B 45 213
21st Scot C Scot C
Scot C 22 413


I tried using a formula I found on the Microsoft web site but it worked and
worked and never produced results.

Cols A,B will contain several hundred rows of data while Col D - F will
contain tens of thousands of rows of data. If you could show me a formula
or macro to do this I would really appreciate it.

Gilly

 

[Gilly]

I'm hoping this example is clearer than the last

BDAY |NAME | EMPTY |NAME | AGE |AREA-CODE

5th Jim B Scot C 22 413
18th Ron J Ted F 31 615
21st Scot C Jim B 45 213


AFTER SORTING:


BDAY | NAME | EMPTY | NAME | AGE | AREA-CODE

5th Jim B Jim B Jim B 45 213
21st Scot C Scot C Scot C 22 413




Gilly