SOLVED

Table to Table help

%3CLINGO-SUB%20id%3D%22lingo-sub-3544454%22%20slang%3D%22en-US%22%3ETable%20to%20Table%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3544454%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20project%20I%20need%20help%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20each%20have%20one%20column%20in%20common%20-%20that%20is%20the%20Name%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20rows%20are%20not%20in%20the%20same%20order.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20in%20Table%20A%2C%20there%20is%20a%20column%20called%20Declined%20and%20it%20is%20marked%20with%20%22Yes%22%20or%20%22No%22%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20add%20this%20Declined%20column's%20information%20to%20Table%20B%20without%20going%20through%20each%20row%20(There%20are%20about%20500)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETherefore%2C%20I%20need%20to%20match%20the%20Project%20Name%20in%20Table%20B%20and%20Table%20A%2C%20then%20lookup%20the%20status%20of%20the%20Declined%20column%20(%22Yes%22%20or%20%22No%22)%20in%20Table%20A%20and%20be%20able%20to%20input%20that%20into%20a%20new%20column%20in%20Table%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20time%20and%20help!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3544454%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3544503%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20to%20Table%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3544503%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1376073%22%20target%3D%22_blank%22%3E%40jwenzCHUBB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EYou%20can%20try%20INDEX%20and%20MATCH.%20An%20alternative%20could%20be%20VLOOKUP.%20If%20you%20work%20with%20Office365%20or%202021%20you%20can%20apply%20XLOOKUP%20as%20well.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3544563%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20to%20Table%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3544563%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20attached%20example.%20This%20is%20extremely%20helpful%3C%2FLINGO-BODY%3E
Occasional Contributor

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 Replies
best response confirmed by jwenzCHUBB (Occasional Contributor)
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.

Thanks for the attached example. This is extremely helpful