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
Bookmarks