Forum Discussion
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...
=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"
)