ExcelBanter - A value exists in a list?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - A value exists in a list? (https://www.excelbanter.com/excel-discussion-misc-queries/88943-value-exists-list.html)

Alberto Pinto

A value exists in a list?

Hi!

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

Thanks in advance,

António

Gary''s Student

A value exists in a list?

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

All times are GMT +1. The time now is 09:34 AM.