Check the reply to your other post in this thread.

Mukesh wrote:

Hi Jacob / Dave,

I am trying to get result if the e-mail addresses contains
".us" = USA, ".ae" = UAE, ".jp" = Japan...and so on.

I used =IS(ISNUMBER(SEARCH(".us",C3)),"USA", " ") and
it works fine, but doesn't work if the search is more than 6 times.

I am using xl2003.

Thanks.
Mukesh

"Dave Peterson" wrote:

Are you trying to check for an error when there's no match?

=if(isna(vlookup(e2,Sheet2!$a1:$b$35,2,false)),"",
vlookup(e2,Sheet2!$a1:$b$35,2,false))



Mukesh wrote:

Is it possible to use ISNUMBER & VLOOKUP together?
example =IF(ISNUMBER(VLOOKUP(E2,Sheet2!$A$1:$B$35....I can't
get it right, please help.

Thanks.
Mukesh

--

Dave Peterson


--

Dave Peterson