I figured out the formula =IF(MATCH(A2,A:A,Items!$A:$A),A2,"") but now i need to join that with IF(ISNUMBER(MATCH(CONCATENATE($A2,B$1),Items!$C:$C,0)),"X",""). I tried using an AND statement but I keep on getting an error.