Matching Data between two Workbooks

[tomsnds8]

Hi all,

I am trying to conduct a matching of data between a database of contacts and separate database of enrolments to see whom from the data base has enrolled so far.

As representative example of the two sets of data: My data set:

	A	B	C	D	E	F	G
1	First Name	Last Name	Job title	Institution	Category	Country	Email
2	John	Jones	Manager	JJ Inc	Charity	Kenya	Jonh@jhonmail.com

<tbody>
</tbody>

extrapolated confirmed enrolment data

	A	B	C	D
1	ID code	Email	Name	Profile
2	4567	tim@gmial.com	tim timpson	www.enrolepage4567.org
3	4589	jonh@jhonmail.com	John jones	www.enrolepage4589.org

<tbody>
</tbody>

As you will see the data is slightly different format. What would be best way to a match of data - preferably on my database so i can match up the enrolments. ( I tried Vlookup but got a little muddled). The matching data is either going to be names or emails (noting they some will register with a different email occasionally- so names more likely to be accurate).

Thanks for your time

Cheers
tom

 

[oldbrewer]

A

B

C

D

E

F

G

H

helper

1

First Name

Last Name

Job title

Institution

Category

Country

Email

is enroled ?

2

John

Jones

Manager

JJ Inc

Charity

Kenya

Jonh@jhonmail.com

YES

John Jones

=b4&" "&c4

fred

smith

NO

fred smith

robin

hood

NO

robin hood

extrapolated confirmed enrolment data

A

B

C

D

1

ID code

Email

Name

Profile

2

4567

tim@gmial.com

tim timpson

www.enrolepage4567.org

3

4589

jonh@jhonmail.com

John jones

www.enrolepage4589.org

the YES for john jones derived by

=IF(ISERROR(MATCH(M4,$D$10:$D$100,0)),"NO","YES")

<colgroup><col span="17"></colgroup><tbody>
</tbody>

 

[tomsnds8]

Thanks Oldbrewer- this works exactly how i need it to- thanks for simple instruction - that code for the names is a real bonus for me as well!!

thanks alot- much appreciated
tom

 

[oldbrewer]

you are welcome Tom, this 73 year old brain needs the exercise................