Help determining which Excel formula to use

Question

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!

detlef_lewin · Answer

Mammerman&nbsp;Use XLOOKUP().https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929&nbsp;

juliano-petrukio · Answer

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

Forum Discussion

Help determining which Excel formula to use

2 Replies

Resources