Looking up text in string

Need to consolidate or look up which client deposited funds to our account. On our BANK DATA we see the account number or a reference from whom the transfer is from and I usually just copy the number or reference and look it up (using Clt+f) in our CLINETE DATA BASE.

We receive several deposits a day and it takes time looking up one-by-one. What formula can I use to get excel to look up the client name using the account number or reference from BANK DATA to look for in our CLIENTE DATA BASE.

Or if there is a formula that looks compares data from one column and searches in another to see if some numbers or strings batch.

Example of info used:

BANK DATA

Date

Information

Amount

Client

2/13/2018

SPEI DEPOSIT/0004182807  021 BNET    0178724628

2,340.20

Formula?

2/13/2018

SPEI DEPOSIT/000221 Customs Duties

220.06

Formula?

 

CLIENT DATA BASE

Account or Reference

Client

Fexpress, 0178724628

FedEx Express

Customs Duties, 407223235

IGL Express

2012283350

American Greets

 

By: Arthur

39 thoughts on “Looking up text in string

  1. peptide zum verkauf

    I was suggested this web site by means of my cousin. I am no longer certain whether or not this submit is written by means of him as no one else recognize such designated approximately my difficulty. You are amazing! Thank you!

  2. Melanotan 2 online kaufen

    I have been exploring for a little for any high quality articles or blog posts on this sort of space . Exploring in Yahoo I ultimately stumbled upon this website. Studying this info So i¦m happy to convey that I have a very just right uncanny feeling I found out exactly what I needed. I so much for sure will make certain to do not overlook this web site and give it a glance regularly.

  3. Sibutril in deutschalnd Kaufen

    Hello! I know this is somewhat off topic but I was wondering which blog platform are you using for this website? I’m getting fed up of WordPress because I’ve had issues with hackers and I’m looking at options for another platform. I would be fantastic if you could point me in the direction of a good platform.

  4. Adipex Online Kaufen

    What’s Taking place i am new to this, I stumbled upon this I have found It absolutely useful and it has aided me out loads. I hope to contribute & aid other customers like its helped me. Good job.

  5. sibutramin kaufen

    I¦ll right away grasp your rss feed as I can’t find your e-mail subscription hyperlink or e-newsletter service. Do you have any? Please allow me realize in order that I may subscribe. Thanks.

  6. anabolika jetzt

    I have been absent for some time, but now I remember why I used to love this web site. Thank you, I?¦ll try and check back more often. How frequently you update your website?

  7. www.brilliantlighttherapy.co.uk

    Good V I should definitely pronounce, impressed with your web site. I had no trouble navigating through all tabs and related information ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your client to communicate. Excellent task..

  8. www.shacktube.com

    Hello there, just became alert to your blog
    through Google, and found that it’s truly informative. I am going to watch out for brussels.
    I will be grateful if you continue this in future.
    A lot of people will be benefited from your writing.
    Cheers!

  9. hungary vs immigrants

    Pretty element of content. I simply stumbled upon your web site and in accession capital to say that I acquire actually loved account your blog posts. Any way I’ll be subscribing on your feeds and even I success you get right of entry to consistently fast.

  10. Lyndon Huhn

    Very good written article. It will be useful to anybody who employess it, as well as myself. Keep doing what you are doing – i will definitely read more posts.

  11. sling tv

    I think this is one of the most vital information for me.
    And i’m happy reading your article. However should statement on some common things, The web site taste is great, the articles is actually great : D.
    Just right activity, cheers

  12. Buy Supplements

    Hey this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding knowledge so I wanted to get advice from someone with experience. Any help would be enormously appreciated!

  13. sling tv

    Hi! Do you know if they make any plugins to protect against hackers?
    I’m kinda paranoid about losing everything I’ve worked hard
    on. Any tips?

  14. coconut oil

    Hi there are using WordPress for your blog platform?
    I’m new to the blog world but I’m trying to get started and create my own. Do you
    require any coding expertise to make your own blog? Any help would be really appreciated!

  15. ps4 games

    This design is incredible! You obviously know how to keep a reader entertained.
    Between your wit and your videos, I was almost moved to start my own blog
    (well, almost…HaHa!) Fantastic job. I really enjoyed
    what you had to say, and more than that, how you presented it.
    Too cool!

  16. ps4 games

    Good day! Do you know if they make any plugins to help with SEO?
    I’m trying to get my blog to rank for some targeted keywords but I’m
    not seeing very good success. If you know of any please share.
    Appreciate it!

Comments are closed.