If #REF then load to Query If #VALUE then don't. Need help with loading #REF records

[szakharov7723]

Hello, Can you please help me find a workaround to load needed records

Is there a way to replace #REF error, but keep #VALUE one ?
Or in other way, Is there a way to load #REF records , but exclude #VALUE ones ?

If it helps I use the following formula in order to find keywords. And result with #REF means keywords was found. #VALUE means it wasn't.

=INDEX(list,SUMPRODUCT(ISNUMBER(SEARCH(list,E14))*ROW(list)))

I don't know if SQL, VBA, M may help, but I can also try them if no simpler solution available.

 

[szakharov7723]

I found a bit easier to work with formula, so I would say this topic is closed, unless somebody wants to treat it as a challenge.