Say you have a value in A1 and the list in column B. =MATCH(A1,(B:B),0)
will return #N/A if there is no match.
--
Gary's Student


"Alberto Pinto" wrote:

Hi!

How can i Know if a determined value is present on a array?

Thanks in advance,

António