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