Help determining which Excel formula to use

%3CLINGO-SUB%20id%3D%22lingo-sub-2708309%22%20slang%3D%22en-US%22%3EHelp%20determining%20which%20Excel%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2708309%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20could%20use%20some%20help%20determining%20the%20best%20formula%20to%20achieve%20certain%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%201%20workbook%20that%20contains%202%20sheets.%20Both%20sheets%20contain%20a%20column%20%22Content%20Title%22%20with%20varying%20amounts%20of%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20sheets%20also%20have%20a%20column%20%22Total%20Unique%20Users%22%20but%20Sheet%202's%20column%20has%20data%20in%20it.%20I%20want%20to%20bring%20over%20the%20data%20from%20the%20Sheet%202%20column%20%22Total%20Unique%20Users%22%20to%20Sheet%201%20if%20the%20%22Content%20Title%20in%20Sheet%201%20matches%20in%20Sheet%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20the%20%22Content%20Title%22%20in%20Sheet%201%20is%20equal%20to%20a%20value%20in%20Sheet%202%2C%20pull%20the%20data%20from%20the%20associated%20%22Total%20Unique%20Users%22%20column%20in%20Sheet%202%20into%20Sheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20an%20example%20of%20the%20data%20for%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2708309%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-2708409%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20determining%20which%20Excel%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2708409%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1143700%22%20target%3D%22_blank%22%3E%40Mammerman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20XLOOKUP().%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2708520%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20determining%20which%20Excel%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2708520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(INDEX(Sheet2!B2%3AB4%2CMATCH(A2%2CSheet2!A2%3AA4%2C0)%2C1)%2C%22Not%20Found%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIFERROR(%0A%20%20%20%20INDEX(%0A%20%20%20%20%20%20%20%20Sheet2!B2%3AB4%0A%20%20%20%20)%2C%0A%7B%20%20%20%20%20%20%20%20MATCH(%0A%20%20%20%20%20%20%20%20%20%20%20%20A2%0A%20%20%20%20%20%20%20%20)%2C%0A%7B%20Sheet2!A2%3AA4%0A%20%20%20%20%20%20%20%20)%2C%0A%7B%200%0A%20%20%20%20%20%20%20%20)%0A%20%20%20%20)%2C%0A%7B%201%0A%20%20%20%20)%0A)%2C%0A%7B%20%22Not%20Found%22%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi! I could use some help determining the best formula to achieve certain results.

 

I have 1 workbook that contains 2 sheets. Both sheets contain a column "Content Title" with varying amounts of data.

 

Both sheets also have a column "Total Unique Users" but Sheet 2's column has data in it. I want to bring over the data from the Sheet 2 column "Total Unique Users" to Sheet 1 if the "Content Title in Sheet 1 matches in Sheet 2.

 

For example, if the "Content Title" in Sheet 1 is equal to a value in Sheet 2, pull the data from the associated "Total Unique Users" column in Sheet 2 into Sheet 1.

 

I attached an example of the data for reference.

 

Any help is appreciated. Thank you!

2 Replies

@Detlef Lewin 

=IFERROR(INDEX(Sheet2!B2:B4,MATCH(A2,Sheet2!A2:A4,0),1),"Not Found")

 

=IFERROR(
    INDEX(
        Sheet2!B2:B4
    ),
{        MATCH(
            A2
        ),
{ Sheet2!A2:A4
        ),
{ 0
        )
    ),
{ 1
    )
),
{ "Not Found"
)