Need help please!!!! I have 8 columns and 10 items to look up for within
these columns. I need a function witch will give me a 1 if any of the
the items are in the columns..I have this function to find one item,
but when i try to put more items to be found i get no
result..

thanks

=IF(OR(S2="BGMFIELDNOTIF",U2="BGMFIELDNOTIF",W2="B GMFIELDNOTIF",Y2="BGMFIELDNOTIF",AA2="BGMFIELDNOTI F",AC2="BGMFIELDNOTIF",AE2="BGMFIELDNOTIF",AG2="BG MFIELDNOTIF"),1,
" ")


--
JRIVERA77
------------------------------------------------------------------------
JRIVERA77's Profile: http://www.excelforum.com/member.php...o&userid=31325
View this thread: http://www.excelforum.com/showthread...hreadid=510111