Index Match Vlookup or something else

B

billy2willy

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:
 
G

Guest

Try:

=IF(SUMPRODUCT(--(LEFT(B3:B100,5)=H3)),"AcctFound","AcctNotFound")
in your column J - Cell J3

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 19
Lookup or VLookup or something else?? 2
INDEX+MATCH=slow? 3
Sum Column C for duplicate account number in Column A 8
Index and match across columns 5
Index/Match vs VLookup? 4
vlookup or index(match)? 7
vlookup or index/match formula?? 2

Top