What can I do to match this properly?

[Excellica]

Hi everyone,

I'm facing this challenge:

I have two lists (files) that concern customer club members for a loyalty program.

FILE A contains:
Email | Member number

Example:

Email	Member number
test@test.com	1
try@try.com	2

FILE B contains:
Email | Bonus points

Example:

Email	Bonus points
test@test.com	100
nope@nope.com	200

First, I need to find out which members match from these files.
Next, for the matching members, I need the email AND the bonus points.

EXPECTED RESULT

Example:

Email	Member number	Bonus points
test@test.com	1	100

I know how to match them, but when I get the list of matching members in FILE A, then I don't know how to add the corresponding bonus points from FILE B in a new column next to them.

Can anyone help me to figure this out?

 

[offthelip]

You can use Vlookup in the third column of FileA

 

[DeficientOptimism]

Try this;

Book1
	A	B	C	D	E	F	G	H	I
1	Email	Member number	Bonus points					Email	Member number
2	test@test.com	1	100					test@test.com	1
3	try@try.com	2	200					try@try.com	2
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=INDEX(I:I,MATCH(A2, H:H,0))

 

[RoryA]

Cross-posted here: Match two sheets and add one column from one to the other (excelforum.com)

Please note we have the same cross-posting rules.

 

[Excellica]

@DeficientOptimism: Wow, this did the trick! Thanks a lot! ?