Pulling Information in from another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2632246%22%20slang%3D%22en-US%22%3EPulling%20Information%20in%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632246%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%202013.%26nbsp%3B%20I%20am%20trying%20to%20keep%20track%20of%20billing%20amounts%20per%20client%20that%20is%20billed%20different%20amounts.%26nbsp%3B%20I%20have%20a%20main%20sheet%20that%20has%20the%20billing%20code%20and%20amount%20on%20it.%26nbsp%3B%20I%20want%20to%20create%20a%20log%20that%20keeps%20track%20of%20the%20amounts%20billed%20by%20having%20a%20column%20that%20you%20input%20the%20billing%20code%20and%20in%20the%20next%20column%20have%20a%20formula%20that%20will%20fill%20in%20the%20bill%20amount%20according%20to%20the%20main%20sheet%20that%20has%20all%20the%20billing%20codes%20and%20amounts.%26nbsp%3B%20I%20am%20needing%20help%20in%20the%20formula%20that%20was%20automatically%20fill%20in%20the%20billing%20amount.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2632246%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632308%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20Information%20in%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1124022%22%20target%3D%22_blank%22%3E%40KHeath883%3C%2FA%3E%26nbsp%3BYou%20don't%20give%20away%20much%2C%20but%20I%20guess%20you%20need%20to%20look%20into%20functions%20like%20VLOOKUP%20or%20XLOOKUP.%20More%20about%20those%20in%20the%20link%20below%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632311%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20Information%20in%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632311%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1124022%22%20target%3D%22_blank%22%3E%40KHeath883%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHowever%2C%20in%20order%20to%20receive%20an%20answer%20from%20the%20other%20users%20here%2C%20it%20would%20be%20advantageous%20to%20observe%20a%20few%20rules.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPlease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%20%3CSTRONG%3EClick%20on%20the%20Link%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good Morning,

 

I am using Excel 2013.  I am trying to keep track of billing amounts per client that is billed different amounts.  I have a main sheet that has the billing code and amount on it.  I want to create a log that keeps track of the amounts billed by having a column that you input the billing code and in the next column have a formula that will fill in the bill amount according to the main sheet that has all the billing codes and amounts.  I am needing help in the formula that was automatically fill in the billing amount.

3 Replies

@KHeath883 You don't give away much, but I guess you need to look into  VLOOKUP. More about that in the link below:

https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 

@KHeath883 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!

However, in order to receive an answer from the other users here, it would be advantageous to observe a few rules.

Please include the following info to help others answer your question: Click on the Link
Welcome to your Excel discussion space!

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE Sorry for the lack of information.  I have a worksheet set up with two pages.  The first page is set up with billing codes and amounts like this  

KHeath883_0-1628622057902.png

And a second page with a table set up like this..

KHeath883_1-1628622102719.png

I'm trying to find a formula that when I input the billing code (i.e.) 97016 it will find the amount on page 1 and automatically put that amount on page 2 in the allowable column.