Pulling data from another sheet for codes

[Jeffer_2]

Hello,

I am looking to create an excel sheet to keep track of some billing.

I basically have this set up for each day I work, where in column A I would enter a code, column B I would enter the number of times to bill that code.
Then I would like column C to auto pull the rate for the code from a master code sheet.
I would then multiple B and C for a total in column D (I already have that formula completed).

This is what I have set up for the daily sheet with an example of the data I would put in:

The master code sheet would look like this:

What would the formula look like to put in column C of the daily sheet?

Thanks so much in advance for your help.

Jeff

 

[Joe4]

Welcome to the Board!

Use VLOOKUP, as shown here, to pull your rate from the other sheet.

VLOOKUP from another sheet

Using VLOOKUP from another sheet is very similar to using VLOOKUP on the same sheet. In the example shown, the formula in F5 is: =VLOOKUP(B5,Sheet2!$B$5:$C$104,2,0) VLOOKUP retrieves the correct building for each employee from Sheet2 into the table on Sheet1.

exceljet.net

 

[GlennJ]

try this. change the A2:B18 to as big as you need it and change 'master code sheet' to your sheet name that contains your rates.

=VLOOKUP(A2,'master code sheet'!A2:B18,2,FALSE)

 

[Jeffer_2]

Perfect! Got it to work, thanks so much for your help!