Hello everyone,
I Have one problem. I want to match payment reference to customer name. I have attached excel, where I show the problem and result I wanna see. COuld you please help me, what formula will help me to solve the problem
Hello everyone,
I Have one problem. I want to match payment reference to customer name. I have attached excel, where I show the problem and result I wanna see. COuld you please help me, what formula will help me to solve the problem
Last edited by Rafa100; 03-17-2017 at 03:12 AM.
Sorry, I dont understand what you are doing here, please explain in words, what you are doing
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have changed a presentation. in coloumn J, I have payment reference numbers and customer names. I would like in seperate column customers name to be shown for Payment number starts with PAYIS. Please see attached excel provided.
Last edited by Rafa100; 03-17-2017 at 03:19 AM.
Hi All,
a possible approach.
In K4
=IF(LEFT(J4,5)="PAYIS",INDEX(J4:J$16,MATCH(1,INDEX(--(LEFT(J4:J$16,5)<>"PAYIS"),),0)),"")
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Many thanks. It works
Hi,
thanks for sharing feedback.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks