clegge Wrote:
your right - i did not describe the scenario correctly... basically want
a formula that will return
ssbs2 if there is an ssbs value in h2..
an empty cell if there is a value of x in h2
an empty cell if there is a value of y in h2
an empty cell if there is a value of z in h2
if there is any other vaule in h2 i want the formula to show that
value....

hard to exlain... sory about that


thanks again....

=IF(H2=\"SSBS\",\"SSBS2\",IF(OR(H2=\"X\",H2=\"Y\", H2=\"Z\"),\"\",H2))

and if "h2" is the same as "foo!h2" in your original message, then
simply replace all "h2" with "foo!h2" in the above formula.

Regards.


--
BenjieLop


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