software

Hi in column H I have an account code # (5 digits), in column b I have
an account code number followed by a description of the account code.

What I want is a formula in column j that lets me know if the account
code # is somewhere in my b column or if it is a new account code that
I will have to insert into my b column. A simple quot;yesquot; or quot;noquot; would
let me know.

I think this has to do with index or match or maybe even vlooikup?

Can anyone help me with this one?

Thanks --
billy2willy
------------------------------------------------------------------------
billy2willy's Profile: www.excelforum.com/member.php...oamp;userid=21648
View this thread: www.excelforum.com/showthread...hreadid=539325Try:

=IF(SUMPRODUCT(--(LEFT(B3:B100,5)=H3)),quot;AcctFoundquot;,quot;AcctNotFoundquot;)
in your column J - Cell J3

HTH

quot;billy2willyquot; wrote:

gt;
gt; Hi in column H I have an account code # (5 digits), in column b I have
gt; an account code number followed by a description of the account code.
gt;
gt; What I want is a formula in column j that lets me know if the account
gt; code # is somewhere in my b column or if it is a new account code that
gt; I will have to insert into my b column. A simple quot;yesquot; or quot;noquot; would
gt; let me know.
gt;
gt; I think this has to do with index or match or maybe even vlooikup?
gt;
gt; Can anyone help me with this one?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; billy2willy
gt; ------------------------------------------------------------------------
gt; billy2willy's Profile: www.excelforum.com/member.php...oamp;userid=21648
gt; View this thread: www.excelforum.com/showthread...hreadid=539325
gt;
gt;