I'm trying to reach a famous goal: I want to filter a list based on a value and return all items in another column. I have seen lots of pages suggesting a formula part of which is something like this:
=IF($C$4:$C$34=$I$4,ROW($C$4:$C$34)-3,"")
My problem with this part is that it either returns blank, or a constant value for every match (always 1). I have confirmed that $C$4:$C$34=$I$4 returns correct values (TRUE/FALSE) for each row. I don't know how to fix this. Using Excel Pro Plus 2019.
