IF THEN function combined with VLOOKUP

[marcvanderpeet12]

Dear all,


I'm looking for a way for combine a IF THEN and VLOOKUP function. I need to perform a VLOOKUP and if the value is not in the VLOOKUP list, it has to show the value "NOT" (in stead of "N/A".


Anybody some input on how i can do this?


Dear regards,


Marc

 

[mahaveer]

UPLOAD A SAMPLE FILE FOR BETTER ANSWER

 

[Faseeh]

marcvanderpeet12,


Try this:


=IF(ISERROR(VLOOKUP())=TRUE,"NOT",VLOOKUP())


Regards,