Thanks Mike
--
Regards

Glynn Taylor


"Mike H" wrote:

Try

=IF(COUNTIF(A1:D4,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" wrote:

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

Glynn Taylor