Welcome to the forum.

Are you entering =IF(B3:B13=$L$1,A3:A13,"") into an array range? I think it would help us if you mocked up an example spreadsheet and attached it to the thread for us to see. If you're asking for what I think you're asking for then, yes, it is possible to do it with formulas but it is not simple and there are better alternatives. I'll reserve my recommendation until I'm 100% clear on exactly what you need.