IF & VLOOKUP Formula Only Returning First Value Found
I'm having a problem where I'd like the formula in [Column 3] to report the value in [Primary Column] only if the checkbox in [Column 2] is TRUE (checked). (In the real sheets, the VLOOKUP formula in [Column3] is on another sheet from the values in [Primary Column]:[Column2] here, otherwise I'm sure it's much more straightforward to reference the actual cells themselves.)
However, it looks like formula will only pull the first value from the top that it comes across that matches its criteria. In the example photo, the second "A" in [Primary Column] isn't being reported, instead displaying "woof" (IF formula found a false statement).
Ideally, when the VLOOKUP sees that the first "A" value in [Primary Column] is unchecked (false), the formula should move on and find the next instance where "A" appears AND [Column2] is checked to report that instead.
Is there a way to get that to work?