Apple Numbers issues/error IF(SUMPRODUCT( ISNUMBER(SEARCH(

I have done the below formula in excel, works fine. But I need to get this working in Apple Numbers, but I have issues

IF(SUMPRODUCT(−−ISNUMBER(SEARCH(A1,$C$2:$C$9))),"Used","")

It somewhat works, but doesn't fully. The issues it has is:
- it won't accept multiple cells as the search field (The range C2:C9 can?t be used as a single value), which only appears in row 1, and 10 onwards (so not the 2-9)
- it doesn't search across the cells, e.g it will only search rows 2-9 and not additional rows e.g rows 10 on wards
- The formula uses a Boolean in place of a number. (whatever this means)

Is there another way to do my formula in apple numbers?

I've attached the working excel version but if you open it in numbers and put in the formula you will see the issue.

Sorry not sure what happened should be attached now

Also now half fixed. Did a Concatenate in column E and merge E2-E9 together (and then hid column E) and now it works with the below formula.

IF(SUMPRODUCT(−−ISNUMBER(SEARCH(A1,$E$2))),"Used","")

But I am stilling getting the below error, which has a little blue thing in the corner which is annoying. Any way to fix it?
The formula uses a Boolean in place of a number.

Resolved
Removed the SUMProduct
It is now just
IF(ISNUMBER(SEARCH(A1,$E$2)),"Used","")