Index Match Vlookup or something else

Giganews Newsgroups
Subject: Index Match Vlookup or something else
Posted by:  billy2willy (billy2willy.27cenm_1146846300.5454@excelforum-nospam.com)
Date: Fri, 5 May 2006

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 "yes" or "no" 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 :cool:

--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=21648
View this thread:http://www.excelforum.com/showthread.php?threadid=539325

Replies