Match with two different sheets and collects data to show in Final

[Kaiser]

Dear Users,

Regards, I was working on a School Monthly Fees, I have designed an excel sheet which has the Full Data's of the Student and a Final Tab where we will collect all the Student Details from the Account Tab and the respective bills from a different sheet name Monthly Fees. I am sure the excel file will be self explanatory. I have also highlighted the output in red as an example. I am sure how I can match and collect the figures and give such a result. I am sure someone will really help me with the problem. I have attached both the excel sheet. Take care and best wishes.

Kaiser

 

[azumi]

You have non matching names and Bill Details:

Sarif Muhtasibur Rahman with
Sakif Muhtasibur Rahman

and some other name

And

Stationary Supplies with
Stationery Supplies

Tution Fees with
Tuition Fees
and some other exmples

How you come with that non matches value? but pls see the file attach

 

[Abhishekbasti]

Hi Kaiser,

Please bellow attached Solved sheet. If you have any concern Please let me know.

 

[Kaiser]

I will try the file and let you know the feedback....thanks a lot..