Table to Table help

Hi all,

I have a project I need help with.

I have two tables.

They each have one column in common - that is the Name column. 

The rows are not in the same order. 

Now in Table A, there is a column called Declined and it is marked with "Yes" or "No" 

I want to be able to add this Declined column's information to Table B without going through each row (There are about 500)

Therefore, I need to match the Project Name in Table B and Table A, then lookup the status of the Declined column ("Yes" or "No") in Table A and be able to input that into a new column in Table B.

Thanks for your time and help!