I'm sure this has been asked before, I've searched everywhere and can't find it. I am so struggling to create a formula that will look up a specific variable in a list of variables and then look for the latest occurrence of that variable and return that date. For example, if the range of variables and dates are listed below in A1:B21 and the specific variable is "Yellow" (C2) then the formula in D2 would return 9/17/2014 (the last occurrence of the target variable). Any help would be so very much appreciated! Thanks guys!