Try this:
=IF(A6="","",IF(VLOOKUP(A6,CSM,8)="X","X",IF(VLOOK UP(A6,NPM,8)="X","X",IF(VLOOKUP(A6,PM,8)="X","X","
"))))
when A6 is blank, your target cell will return a blank, when A6 is not
blank, the remainder of your formula is processed.
Note: I notice you have the formula return a space (" ") if none of
the ranges contain "X". If you want simply to return a blank cell, use
"" (without the space between the quote marks).
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=380513