Find if value exits in array

[Glynn]

I need to determine if a numeric value held in a cell exists is a multy row,
multy column array of numeric values

 

[Mike H]

Try

=IF(COUNTIF(A14,E1)>0,"It's there","It's not there")

Where
a1 - D4 is your array
E1 contains the number you are looking for

Mike

 

[Dave Peterson]

=COUNTIF(B3:X99,A1)
will return the number of times the value in A1 is in B3:X99.

=countif(b3:x99,a1)>0
will return true or false

change your addresses to match what you need.

 

[Teethless mama]

=countif(A:F,your_numeric_value)

 

[Glynn]

Thanks Mike
--
Regards

Glynn Taylor

Try

=IF(COUNTIF(A14,E1)>0,"It's there","It's not there")

Where
a1 - D4 is your array
E1 contains the number you are looking for

Mike

 

[Glynn]

Thanks Teethless
--
Regards

Glynn Taylor

=countif(A:F,your_numeric_value)

 

[Glynn]

Thanks Dave
--
Regards

Glynn Taylor

=COUNTIF(B3:X99,A1)
will return the number of times the value in A1 is in B3:X99.

=countif(b3:x99,a1)>0
will return true or false

change your addresses to match what you need.