I have a Visible tab that VLOOKUP to a Hidden tab for dates. Not every cell has a date so it returns nothing. However, when I filter a column, "1900" is a selection. How do I not make it a selection by the "filter" option? I've tried custom format cells but nothing is working. Please see attached.
Bookmarks