View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonathan Horvath Jonathan Horvath is offline
external usenet poster
 
Posts: 20
Default 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