ISERROR Comment

[Johnny Thunder]

Hello Friends,



I am using this formula: =IF(AND(J2<>"C1313000",J2<>"C1313001"),VLOOKUP(H:H,DEfinitions!A:B,2,0),"")

And what it says is; If you see the "C1313000" or "C1313001" don't do the Vlookup and return blank. but now I need to be able to also say in the same formula if you do the vlookup and don't find the criteria you are looking for retunr the comment "AddToDef" and I am not sure how to enter the formula?


Normally when I do a Vlookup and want a comment I would use something like this. =If(ISERROR(VLOOKUP(H:H,DEfinitions!A:B,2,0),"ADDTODEF",VLOOKUP(H:H,DEfinitions!A:B,2,0))) but I got all that "IF" / "AND" formula in there so it doens't work?


I feel like I am just writing it wrong? any help would be much appreciated. Thanks!!


Excel 2003

 

[barry houdini]

You can still replace the VLOOKUP with your ISERROR version but you have a misplaced parenthesis, try like this

=IF(AND(J2<>"C1313000",J2<>"C1313001"),IF(ISERROR(VLOOKUP(H2,DEfinitions!A:B,2,0)),"ADDTODEF",VLOOKUP(H2,DEfinitions!A:B,2,0)),"")

 

[Johnny Thunder]

thanks for all your help!