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