Try with a test data

=IF(ISNUMBER(VLOOKUP(1,A1:B5,2,FALSE)),"Numeric"," Not a numeric")


If this post helps click Yes
---------------
Jacob Skaria


"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