• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating billing in excel

T

taia

New Member
Hello All,


I am wondering if there is an equation in excel that would help me select a persons name and incorporate some products purchased. I have all products on one tab with fee's, all customer's on another tab, and a tab with a billing "shell". I would like to select one person for the bill but bring in their specific order. This is for multivitamin sales referred from a doctor so the individuals order shouldn't change very often. I there some if then statement that could help?


Thanks to anyone who can help!

Taia
 
Taia


Firstly, Welcome to the Chandoo.org Forums


I'd start by using an Index/Match lookup


Refer: http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/

or

http://chandoo.org/wp/2010/11/02/how-to-lookup-values-to-left/
 
You must log in or register to reply here.
Back
Top