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.