Hi! How can i Know if a determined value is present on a array? Thanks in advance, António
A Alberto Pinto May 16, 2006 #1 Hi! How can i Know if a determined value is present on a array? Thanks in advance, António
G Gary''s Student May 16, 2006 #2 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.
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.
