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

3 thoughts on “Looking up text in string

Leave a Reply

Your email address will not be published. Required fields are marked *