Okay guys

Column A has a load of ref numbers...
Column B has the amount that each ref number has paid..
Column C is customer name


Column D again has ref numbers but these are in different order etc..
Column E is blank and needs to present how much each of the above ref number has paid.

To get these figures.

Column D1 needs to find a match in column A:A and what ever is to the right of column A:A on the match in B it needs to paste the amount paid...

e.g. D1 searches column A:A and finds it match at A17 it then neeeds to paste into E1 what it says next o a17 in B17

Please can anyone help..