ISNUMBER & VLOOKUP
Mukesh
The below formula applies only if you have a match.. If you want to handle
that use ISNA() or ISERROR() or if you are using 2007 use IfERROR().
=IF(ISNA(formula),"",VLOOKUP)
=IF(ISERROR(formula),"",VLOOKUP)
If this post helps click Yes
---------------
Jacob Skaria
"Mukesh" wrote:
I still can't get it right.....I get #N/A......my code is
=IF(ISNUMBER(VLOOKUP(C214,Email.Filters!$A$1:$B$15 ,2,FALSE)), " ",
VLOOKUP(C214,Email.Filters!$A$1:$B$15,2,FALSE))
I am trying to look for part of the word, infact using
=IF(ISNUMBER(SEARCH works, but since the list is long I think Vlookup should
be the right way to do...please help.
Thanks.
Mukesh
"Jacob Skaria" wrote:
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
|