Hi, i am new to this forum and request some help on excel.
i intend to use 3 conditions on the below table. the formula i used is =if(isnumber(match(b2,A2:A5,0)*AND(c2="",b2,0) however i am unable to extract the required result.
<colgroup><col><col><col><col><col><col></colgroup><tbody>...