__should__solve my problem, but so far none have worked. One thing I have noticed with many of these examples is the requirement to press 'Control + Shift + Enter' for an array formula. I have Excel 2013 and no brackets appear and I'm not sure if this is necessary in 2013 as I have several other array formulas that work without doing this. I've researched this but can't find anything to indicate or rule out this requirement in 2013 but wanted to note that I tried it anyway but nothing happens. On some of the examples I found I literally cut and pasted all tables and formulas but still could not get anything to work.

My setup - I have a worksheet with roughly 8,000 stock symbols (example: AAPL, MSFT, etc) in column A. I have dates in column B that list the expected Earnings Announcement dates for the corresponding stock symbol in column A. In cell C1 I use "TODAY()" for the reference date. I'm trying to write a (copy down) formula in column D that would return all stock symbols from column A that have Earnings Announcements matching the date in C1.

I've tried 30 to 40 different formulas and nothing works. I've tried several combinations using INDEX/MATCH/COUNTIF/SMALL etc but can't figure out where I am going wrong. Hopefully someone here can offer some suggestions. Thanks!!