1) basically would like to get the following statement to work:
=if(foo!H2=ssbs,"ssbs2","foo'!H2")
basically if fooH2 contains the value SSBS i need to return SSBS2 if it
does not i need to return the value that is presently in fooH2

2) if possiple i would like to make it a compound if ..
if foo!H2=ssbs, then return ssbs2, if foo!H2 = x then return x2, if
foo!H2=x then return x3

thank you in advance for all the help....


--
clegge
------------------------------------------------------------------------
clegge's Profile: http://www.excelforum.com/member.php...o&userid=29927
View this thread: http://www.excelforum.com/showthread...hreadid=499793