I have a formula as below, which checks two cells for a MATCH with Datatable1 (assigned a Name with some data). Here if either of one cell matches with Datatable1, then it writes the value in I7.
IF(OR((ISNUMBER(MATCH($L7;DataTable1;0))=TRUE);(ISNUMBER(MATCH($O7;DataTable1;0))=TRUE));$I7;"")
Is it possible to condense the formula with single MATCH function and check $L7 or $O7 matches with Datatable1? Only reason is to shorten the formula.
Aucun commentaire:
Enregistrer un commentaire