{=RIGHT(INDEX(Basis!$G$78:$G$90000;MAX(IF(IF(Basis!$G$78:$G$90000<>"";LEFT(Basis!$G$78:$G$90000;78)*1)=MAX(IF(Basis!$G$78:$G$90000<>"";LEFT(Basis!$G$78:$G$90000;78)*1));IF(Basis!$I$78:$I$90000="committed";ROW(Basis!$G$78:$G$90000)-ROW(Basis!$G$78)+1))));2)}


This is what I have in the cell