finding out presence of a value in an array

[alapatik]

Hi,

I have list of values and I need to findout if these values present in an 1-dimensional array. If found, Yes.

Is there any excel formula (not vba code) to meet this requirement? Please help me.

Thanks in advance.

Kalyan.

[watersev]

hi alapatik, you could use Match formula

[Domski]

Something like:

=IF(ISNUMBER(MATCH(Value,A1:A100,0)),"Yes","No")

Dom

[alapatik]

Thanks a lot. Got it