Hi Barb,

The =TRUE is redundant as the expression IF(x,y,z) evaluates whether x is
TRUE by default and if the z-parameter is ommitted and x-parameter is not
TRUE then FALSE will be returned by default too.

Regards,
KL


"Barb Reinhardt" wrote in message
...
Try this

=IF(ISNA(VLOOKUP(I3,marke****ch,1,FALSE))=TRUE,"No
Entry",VLOOKUP(I3,marke****ch,1,FALSE))

If you want a blank displayed, change "No Entry" to "".


"carl" wrote in message
...
I use this formula:

=VLOOKUP(I3;marke****ch;1;FALSE)

Can it be modified to not return #N/A ?

Thank you in advance.