Hello All,

I'm back and needing some assistance. I tried to do a Search on this
to see if there was already an answer but wouldn't work. So here we
go.

What I'm trying to do is the following:

I want to compare two cells w/ text in them and want to return a text
result based off of a particular text string. May sound confusing but
will try and draw it.

The equation I have so far is

=IF(SEARCH("TS",B9), IF(SEARCH("TS",C9),"YY","YN"),
IF(SEARCH("TS",C9),"NY","NN"))

What this is doing is looking into cell B9 to find "TS", if that is
true then will look into C9 for "TS" and if that is true, will display
YY in the cell. This part of the formula works.

However, when I put something other than a TS or leave it blank in B9
or C9...the result is #VALUE!

The problem that I'm having is that I need the result to be YN or NY or
NN. Anything w/ a false result won't work.

Hope you understand what I'm asking...any assistance will be good.

Thanks,

Jason


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=552484