Match two sheets and add one column from one to the other

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
[email protected] | 1
[email protected] | 2

FILE B contains:
Email | Bonus points

Example:
Email | Bonus points
[email protected] | 100
[email protected] | 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
[email protected] | 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?

I have posted the same question here as well, but only because it's very urgent due to my work situation:
https://www.mrexcel.com/board/thread...perly.1159132/