SOLVED

Linking Data Accross Tabs

%3CLINGO-SUB%20id%3D%22lingo-sub-1998902%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Data%20Accross%20Tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1998902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F905464%22%20target%3D%22_blank%22%3E%40escramer93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20XLOOKUP()%2C%20VLOOKUP()%20or%20INDEX%2FMATCH.%20Could%20you%20provide%20small%20sample%20file%20to%20illustrate%20how%20it%20could%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1998880%22%20slang%3D%22en-US%22%3ELinking%20Data%20Accross%20Tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1998880%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello!%20I%20am%20trying%20to%20match%20up%20data%20from%20one%20column%20in%20sheet%20A%20that%20shows%20the%20name%20of%20a%20person%20and%20match%20that%20with%20the%20identical%20name%20from%20a%20sheet%20B.%20I%20would%20then%20want%20it%20to%20reference%20the%20value%20from%20a%20different%20column%20in%20sheet%20B%20and%20pull%20that%20info%20into%20a%20column%20in%20Sheet%20A.%20Any%20help%20here%20would%20be%20greatly%20appreciated!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1998880%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1998997%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Data%20Accross%20Tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1998997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Badded%20to%20original%20post!%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1999308%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Data%20Accross%20Tabs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F905464%22%20target%3D%22_blank%22%3E%40escramer93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you.%20That%20also%20depends%20on%20which%20version%20of%20Excel%20you%20are%20could%20be.%20Some%20variant%20could%20be%20(same%20sequence%20as%20here)%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20534px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241436iC1E7459E77EADC95%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DXLOOKUP(A2%2CSheet2!A%3AA%2CSheet2!B%3AF)%0A--%0A%3DINDEX(Sheet2!B%3AF%2C%20MATCH(Sheet1!A3%2CSheet2!A%3AA%2C0)%2C0)%0A--%0A%3DINDEX(Sheet2!%24B%3A%24F%2C%20MATCH(%24A4%2CSheet2!%24A%3A%24A%2C0)%2CMATCH(C%241%2CSheet2!%24B%241%3A%24F%241%2C0))%0A(this%20one%20drag%20to%20the%20right)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello! I am trying to match up data from one column in sheet A that shows the name of a person and match that with the identical name from a sheet B. I would then want it to reference the value from a different column in sheet B and pull that info into a column in Sheet A. Any help here would be greatly appreciated!

5 Replies

@escramer93 

That's XLOOKUP(), VLOOKUP() or INDEX/MATCH. Could you provide small sample file to illustrate how it could be done?

@Sergei Baklan added to original post! Thank you!

Best Response confirmed by escramer93 (New Contributor)
Solution

@escramer93 

Thank you. That also depends on which version of Excel you are could be. Some variant could be (same sequence as here)

image.png

=XLOOKUP(A2,Sheet2!A:A,Sheet2!B:F)
--
=INDEX(Sheet2!B:F, MATCH(Sheet1!A3,Sheet2!A:A,0),0)
--
=INDEX(Sheet2!$B:$F, MATCH($A4,Sheet2!$A:$A,0),MATCH(C$1,Sheet2!$B$1:$F$1,0))
(this one drag to the right)

@Sergei Baklan Thank you very much you just saved me a lot of time!

@escramer93 , you are welcome, glad to help