looking up or comparing data from one column to another

[arthur85]

Hello all,
I am new to the site and looking to learn how to work more efficiently using excel formulas.

Need help looking up which client deposited funds to our account. In 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 CLIENT 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 CLIENT DATA BASE?

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

I have attached an excel sheet which shows the kind of information I am trying to identify.

BANK DATA
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]DATE[/TD]
[TD]INFORMATION[/TD]
[TD]AMOUNT[/TD]
[TD]CLIENT[/TD]
[/TR]
[TR]
[TD]3/1/2018[/TD]
[TD]SPEI DEPOSIT/0004182807 021 BNET 0178724628[/TD]
[TD="align: right"]2340.20[/TD]
[TD]Formula?[/TD]
[/TR]
[TR]
[TD]3/1/2018[/TD]
[TD]SPEI DEPOSIT/000221 Customs Duties [/TD]
[TD="align: right"]220.06[/TD]
[TD]Formula?[/TD]
[/TR]
[TR]
[TD]3/2/2018[/TD]
[TD]DEPOSIT/REFBNTC00573678 Ref of Bal R170708e BMRCASH[/TD]
[TD="align: right"]65.12[/TD]
[TD]Formula?[/TD]
[/TR]
[TR]
[TD]3/2/2018[/TD]
[TD]ACH TRANSACTION/ USA TRANZ ***4388[/TD]
[TD="align: right"]122.00[/TD]
[TD]Formula?[/TD]
[/TR]
[TR]
[TD]3/2/2018[/TD]
[TD]ACH TRANSACTION/ AMER ACCT 2012283350[/TD]
[TD="align: right"]182.76[/TD]
[TD]Formula?[/TD]
[/TR]
[TR]
[TD]3/2/2018[/TD]
[TD]WT FED#01881 COOPER STANDARD AU[/TD]
[TD="align: right"]7654.11[/TD]
[TD]Formula?[/TD]
[/TR]
</tbody>[/TABLE]
Where it says "Formula" I would like for the client name to appear.
Data marked in BOLD is the account number or reference which I use to identifies who the deposit is coming from.

CLIENT DATA BASE
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ACCOUNT OR REFERENCE[/TD]
[TD]CLIENT[/TD]
[/TR]
[TR]
[TD]Fexpress, 0178724628[/TD]
[TD]FedEx Express[/TD]
[/TR]
[TR]
[TD]Customs Duties, 407223235[/TD]
[TD]IGL Express[/TD]
[/TR]
[TR]
[TD]2012283350[/TD]
[TD]American Greets[/TD]
[/TR]
[TR]
[TD]12344388[/TD]
[TD]USA TRANZ [/TD]
[/TR]
[TR]
[TD]COOPER STANDARD AU[/TD]
[TD]COOPER STANDARD AU[/TD]
[/TR]
</tbody>[/TABLE]
When a new deposit comes in I look on this sheet to match the information from bank data to this (client data base) sheet.

Thank you all for your help.