Formula Assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-2611358%22%20slang%3D%22en-US%22%3EFormula%20Assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611358%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20the%20formula%20to%20match%20a%20unique%20value%20across%20worksheets%20and%20enter%20a%20value%20from%20the%202nd%20sheet%20into%20the%20first%20sheet.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%2C%20sheets%201%20and%202%20contains%20names%20and%20addresses%20and%20I%20need%20to%20match%20the%20names%20and%20then%20enter%20the%20address%20from%20sheet%202%20into%20sheet%201%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2611358%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-2612088%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2612088%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120510%22%20target%3D%22_blank%22%3E%40dwiser47%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20any%20more%20information%20than%20that%2C%20one%20can%20only%20offer%20very%20general%20suggestions.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20has%20long%20had%20a%20function%20called%20%3CSTRONG%3EVLOOKUP%3C%2FSTRONG%3E%20which%20can%20look%20in%20a%20table%20for%20a%20match%20to%20some%20ID--such%20as%20name--and%20then%20retrieve%20adjacent%20columns%20of%20data.%20VLOOKUP%20is%20one%20of%20the%20most%20commonly%20used%20of%20all%20the%20functions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20newer%20and%20more%20powerful%20variations%20on%20that%20tried%20and%20true%20standard.%3C%2FP%3E%3CP%3E%3CSTRONG%3EINDEX%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EMATCH%3C%2FSTRONG%3E%2C%20used%20together%20is%20one%20example.%3C%2FP%3E%3CP%3E%3CSTRONG%3EXLOOKUP%3C%2FSTRONG%3E%20is%20another.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20link%20to%20a%20website%20that%20can%20explain%20how%20those%20functions%20work.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20need%20further%20help%2C%20though%2C%20ay%20I%20suggest%20you%20come%20back%20with%20a%20sample%20of%20your%20actual%20data%2C%20just%20removing%20real%20names%20and%20any%20confidential%20information.%20Create%20a%20mockup%20of%20the%20way%20your%20data%20are%20arrayed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to figure out the formula to match a unique value across worksheets and enter a value from the 2nd sheet into the first sheet.

For example, sheets 1 and 2 contains names and addresses and I need to match the names and then enter the address from sheet 2 into sheet 1

1 Reply

@dwiser47 

 

Without any more information than that, one can only offer very general suggestions. 

 

Excel has long had a function called VLOOKUP which can look in a table for a match to some ID--such as name--and then retrieve adjacent columns of data. VLOOKUP is one of the most commonly used of all the functions.

 

There are newer and more powerful variations on that tried and true standard.

INDEX and MATCH, used together is one example.

XLOOKUP is another.

 

Here's a link to a website that can explain how those functions work. https://exceljet.net

 

If you need further help, though, ay I suggest you come back with a sample of your actual data, just removing real names and any confidential information. Create a mockup of the way your data are arrayed.