How to lookup

I have two sheets; sheet A – booking and sheet B – payment
In sheet A – booking i have 4 columns (A-D)
Date invoice #. name amount
3/1/17 001 Abc 1700
3/1/17 001 Abc 300
1/1/17 011 Snc 888
1/2/17 012 Snc 888
11/1/17 008 Xyz 3000
19/1/17 007 Xyz 400
19//17 007 Xyz 400
5/1/17 003 Klm 200
5/2/17 004 Klm 200

In sheet B payment i also have 4 columns (A-D)
Date Payment ref. Name Amount
3/1/17 Rvs4713 Abc. 2000
1/1/17 Rvs4726 Snc 888
1/2/17 Rvs7420 Snc 888
11/1/17 Rvs3333 Xyz 1500
11/1/17 Rvs3333 Xyz 1500
20/1/17 Rvs1278 Xyz 800
5/1/17 Rvs5906 Klm 198 (bank chg 2)
7/2/17 Rvs1105 Klm 198(bank chg 2)

My problem is i dont know how to pull the payment ref in sheet B to column E in sheet A
How do i do this using formula?

Please help !!

Thanks

By: Rudy

Leave a Reply

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