Array Formula Pulling #N/A

[Sooner4Life]

I have a spreadsheet that tracks stocks and moves on to the next group when one date passes. The problem I'm having is once it passes for that group it generates a #N/A rather than "".
I inserted the IFERROR at the beginning hoping to blank them but didn't work. Any help would be appreciated.

 

[6StringJazzer]

Can you describe what result you are expecting to see in this specific case instead of the error?

It would help if we had actual data instead of a picture, so we can try your formula on your data.

The first thing I noticed is that you have entered this formula as an array formula, but this is not necessary because FILTER is already an array function. You should hit F2 then ENTER. I doubt that will fix your problem but it's easy to do.

Which cell is $T$3? Your ETFs column data is all of the format "Weekly Payers & Group X ETFs" but there is no cell visible that will give you a match for those.

 

[Peter_SSs]

Two suggestions to get better help:

1. Update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

2. As mentioned in post 2, give us the sample data in a form we can copy to test with. MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.