Return value if conditions are met

HH_BE1894

I'm working on a project summary report where I want to pull over the {B2B Mktg - Spend} cell of the sheet I'm referencing where the year matches the parent, quarter matches the metric@row and the row level of that other sheet is 1. See the summary snapshot and formula attempt below. What am I missing?

=IF(AND({B2B Mktg - Year} = PARENT(), {B2B Mktg - Qtr} = Metric@row, {B2B Mktg - Level} = 1), {B2B Mktg - Spend}, " ")

Eric Law

@HH_BE1894 So an IF doesn't do any match for you, and what your IF TRUE is bringing back is an array. I would recommend you use an index match instead of just an if.