Thanks for the reply ben_hensel. I understand what you are saying but I’m not actually looking to sort via date.

I just want a unique or filter or index+match formula to search from the bottom of the column to the top of the column. (Instead of the default of top to bottom) I have seen other people use this formula =LOOKUP(2,1/(A2:A100=C2),B2:B100) but my issue with that is it only seems to populate one result and not display an array of all results for a given criteria.