software

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=quot;BGMFIELDNOTIFquot;,U2=quot;BGMFIELDNOTIFquot;,W2=quot;B GMFIELDNOTIFquot;,Y2=quot;BGMFIELDNOTIFquot;,AA2=quot;BGMFIELDNOTI Fquot;,AC2=quot;BGMFIELDNOTIFquot;,AE2=quot;BGMFIELDNOTIFquot;,AG2=quot;BG MFIELDNOTIFquot;),1,
quot; quot;)--
JRIVERA77
------------------------------------------------------------------------
JRIVERA77's Profile: www.excelforum.com/member.php...oamp;userid=31325
View this thread: www.excelforum.com/showthread...hreadid=510111Not sure I understand fully, have you tried V Lookup?

quot;JRIVERA77quot; wrote:

gt;
gt; Need help please!!!! I have 8 columns and 10 items to look up for within
gt; these columns. I need a function witch will give me a 1 if any of the
gt; the items are in the columns..I have this function to find one item,
gt; but when i try to put more items to be found i get no
gt; result..
gt;
gt; thanks
gt;
gt; =IF(OR(S2=quot;BGMFIELDNOTIFquot;,U2=quot;BGMFIELDNOTIFquot;,W2=quot;B GMFIELDNOTIFquot;,Y2=quot;BGMFIELDNOTIFquot;,AA2=quot;BGMFIELDNOTI Fquot;,AC2=quot;BGMFIELDNOTIFquot;,AE2=quot;BGMFIELDNOTIFquot;,AG2=quot;BG MFIELDNOTIFquot;),1,
gt; quot; quot;)
gt;
gt;
gt; --
gt; JRIVERA77
gt; ------------------------------------------------------------------------
gt; JRIVERA77's Profile: www.excelforum.com/member.php...oamp;userid=31325
gt; View this thread: www.excelforum.com/showthread...hreadid=510111
gt;
gt;


See if this works for you:

=IF(ISNUMBER(SEARCH(quot;BGMFIELDNOTIFquot;,S2amp;U2amp;W2amp;Y2amp;AA 2amp;AC2amp;AE2amp;AG2)),1,quot;
quot;)

That will determine if BGMFIELDNOTIF exists anywhere in those cells.
Note: it will also match if that string is embedded within a cell.
Example: aaaBGMFIELDNOTIFbbb

Otherwise, if you need cell content matches, maybe this with will suit
your needs:
=IF(SUMPRODUCT(((S2:AG2)=quot;BGMFIELDNOTIFquot;)*MOD(COLU MN(S2:AG2),2))gt;0,1,quot;
quot;)

Does that help?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=510111