Limit to nested IF(ISNUMBER(SEARCH)) functions?
Hi Ron,
Thanks, you're correct in that this is rather complicated. My thought was
to search for "ra" first and have that return "ajar" then "ezx" to return
"ezx", then "umts" etc for "umts" and so on... which is why i started with
the IF(isnumber(search)), it was working, but unfortunately I can't have
enough nests.
hmmmmm....
Jonathan
|