Home

Match up columns with name and number

%3CLINGO-SUB%20id%3D%22lingo-sub-750456%22%20slang%3D%22en-US%22%3EMatch%20up%20columns%20with%20name%20and%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750456%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Yall%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20a%20sample.%20I%20currently%20have%20two%20tables%20(the%20one%20on%20the%20left%20needs%20to%20stay%20the%20way%20it%20is).%20I%20am%20trying%20to%20match%20the%20right%20table%20with%20its%20corresponding%20value%20to%20the%20left%20table.%20Any%20help%20would%20be%20extremely%20appreciated%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-750456%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-750601%22%20slang%3D%22en-US%22%3ERe%3A%20Match%20up%20columns%20with%20name%20and%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750601%22%20slang%3D%22en-US%22%3EIn%20Column%20E%2C%20you%20may%20use%20a%20simple%20VLOOKUP%2C%20like%20this%3A%3CBR%20%2F%3E%3DVLOOKUP(D1%2C%3CBR%20%2F%3EA%3AB%2C%3CBR%20%2F%3E2%2C0)%3C%2FLINGO-BODY%3E
chughes49
Occasional Visitor

Hey Yall,

 

I attached a sample. I currently have two tables (the one on the left needs to stay the way it is). I am trying to match the right table with its corresponding value to the left table. Any help would be extremely appreciated thanks!

 

1 Reply
In Column E, you may use a simple VLOOKUP, like this:
=VLOOKUP(D1,
A:B,
2,0)