How to create monthly bills automatically?

HI EXCEL EXPERTS!

I have started a small business with more than 25 suppliers as a CLIENT of mine. I maintain their record in excel but not in an organized way. So, I googled for some new ideas and found many many helpful things. But not as exact as I am willing.

Problem Scenario:
I made a VLOOKUP formula that brings out the complete information of my desired client via putting "CLIENT #" but how to bring out the specified billing information of my desired month of that particular client? In simple words, I want to have the billing information like quantity and rate of my desired month i.e. JULY 2013 or AUG 2013 of my inserted Client.

What I want is that I just put the client # so that it brings out the complete info and then i put the billing month so that it brings out the billing information of that client. And for another bill, I just change the client # and It will automatically change the billing details while remaining the billing month same.

I hope you guys get my prob.

I'm looking forward for your reply. I need to maintain it ASAP.
or
Guide me better but Keeping in mind that I'm a NOOB :v

P.S. Screenshot is attached for better understanding.

SC.jpg

Originally Posted by FDibbins

Hi and welcome to the forum


Actually screenshots are generally terrible "for better understanding"
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Thanks for the welcome!

Yes! you are right therefore, I use a sample and fake info in order to make a question.