Get UDF to return True or False

[YasserKhalil]

Hello everyone
I have values in range("C5:G5") .. and I need to build UDF that searches specific value in this range but range C5:G5 is stored as an array



Example:
The values in range("C5:G5") are 13 / 22 / 33 / 34 / 47

arrTemp=range("C5:G5").value

The value to search is 34

I imagine the following UDF
SearchInAnArray(the value{34},arrTemp)

The result in that case would be True as the value 34 existing the array arrTemp

Thanks advanced for help

[Pete_UK]

Do you really need a UDF for that? You can do it with this formula:

=ISNUMBER(MATCH(34,C5:G5,0))

Hope this helps.

Pete

[MickG]

Perhaps:-

Please Login or Register  to view this content.

Regards Mick

[YasserKhalil]

@Pete
Thanks a lot but need UDF for another sub routine so formulas are not suitable (although it is easier here)
@MickG
Thank you very much for quick and perfect solution. Exactly as needed
Best Regards

[MickG]

You're welcome