We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Find if cell H2 exsiting L range. =IF(COUNTIF($L$2:$L$119,H2)>0,42,E2)