Forum Discussion

Mammerman's avatar
Mammerman
Copper Contributor
Sep 01, 2021

Help determining which Excel formula to use

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 d...
excel
Formulas and Functions
  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Bronze Contributor
    Sep 01, 2021

    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"
)

     

     

     

Resources