Forum Discussion

KHeath883's avatar
KHeath883
Copper Contributor
Aug 10, 2021

Pulling Information in from another sheet

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...
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Aug 10, 2021

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)

  • KHeath883's avatar
    KHeath883
    Copper Contributor
    Aug 10, 2021

    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  

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

    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.

Resources