Help determining which Excel formula to use

[Mammerman]

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]

@Mammerman 

Use XLOOKUP().

https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

[#3]

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