BCDEFGHIJKLMNOPQRST2WorkingWorkingNo Formula3CARLIGHT BLUE2385 CARLIGHT blue2385CARLIGHT blue554CARgrey88CARgrey8CARgrey85CARwhite2013 CARwhite20133CARBLUE20136carblack6324 carblack63244carblack63247cargrey11cargrey1carDARK BLUE1189769=IF(AND(B3="CAR",ISERROR(SEARCH("BLUE",C3)))*(D3=""),E3,"...