Table to Table help

[jwenzCHUBB]

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! 

[#2 · Accepted solution]

@jwenzCHUBB 

You can try INDEX and MATCH. An alternative could be VLOOKUP. If you work with Office365 or 2021 you can apply XLOOKUP as well.

[#3]

Thanks for the attached example. This is extremely helpful