Once you get the isna down pat then you can add the ands and ors

=if(and(isna(vlookup(,,,)), or(find("stw", D2)0, find("iwo", D2)0)), 1, 0)

Without knowing a few more specifics in terms of cell references this is as
far as I can help you...

HTH

" wrote:

I have two columns I want to concentrate on. Column A is
the result of a folmula in the shape of a vlookup.

If the value in A is #N/A I want to take this into
consideration. This is the first thing I dont know how
to do. I also need to take into consideration another
column to get the result I need.

Something like this

=IF(B1="#N/A" AND D2 contains "stw" OR "iwo" THEN "1","0")

I know that is wrong but I know it is possible,

Can someone tell me how to do this. It will be a great
help. Where I have put my "stw" OR "iwo", this 3 letter
seq