close

Is there a function like lookup that will return a true/false value.

if this number on sheet 1 a1 is found anywhere on sheet 2 a1:a10000,
return a value of true or yes, if not return a value of false or no.

Thanks

Wally=ISNUMBER(MATCH(A1,Sheet2!A1:A10000,0))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;WTGquot; gt; wrote in message
...
gt; Is there a function like lookup that will return a true/false value.
gt;
gt; if this number on sheet 1 a1 is found anywhere on sheet 2 a1:a10000,
gt; return a value of true or yes, if not return a value of false or no.
gt;
gt; Thanks
gt;
gt; Wally
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄