Sep 01 2021 09:21 AM
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!
Sep 01 2021 10:35 AM
=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"
)