Forum Discussion

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

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

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.