Hello forum,

I am trying to use the Find formula to test if a particular value matches one of the elements in a named array.

I have created the array in the Name Manager: "SheetLetters" = {"SU","TR","SX"}.

If I put this formula in a cell, =FIND("SU",SheetLetters,1), it returns 1.
but if I use this formula, FIND("SX",SheetLetters,1), it returns #VALUE!

What I would like is for a number to be returned if the search string matches any of the values stored in the array. Any advice would be much appreciated as always.

thanks