look for true, false, when an array is emty or not

  • Thread starter Thread starter Mauricio
  • Start date Start date
M

Mauricio

plz. I need to find a way to retorned a false, true when
the array contine the maching reference or not.
 
Hi Mauricio,

I think this may be what you're after. The array being in
A1:A100 and the reference to match in E1.

=IF(COUNTIF(A1:A100,E1),TRUE,FALSE)

Biff
 
Back
Top