I want to filter the projects in column A by the current fiscal year if the number in the corresponding date column is greater than 0. So in the example uploaded excel the filtered result would be Project 2,3,5 with the Territory and Goal for that fiscal year. I could have sworn I was able to get the proper result before with a Filter/Xlookup combination but I cannot get it to work. Any advice would be greatly appreciated.excel forum upload1.xlsx