# Change the name of a Cell to Text label using another cell and it uses anther value cell for calculations

#### DIGGERDIN

##### New Member
Hello I am using Microsoft Excel 2013.
I am working on an estimating bill of quantities for Civil Engineering.
In the Excel sheet 1 is the summary sheet 2 is the Office over heads and other costs sheet 3 is earth works sheet 4 concrete. In sheet 5 I want to build up the rates to use in each of the sheets.

What I would like to do is in sheet 5 calculate the labour cost and material cost, together they would give me the total cost. I can then use this in any sheet for cost calculations. For example:

In sheet 5: cell B5 is labourer cost of \$15/hr B5=15
In sheet 5: cell D5 is supervisor cost of \$25/hr D5=25
In sheet 5: Now I want L5=(B5*4)+D5 which = 85
In sheet 5: G5=”Team A”,
In sheet 5: I would like H5=L5 therefore H5=85, but the cell H5 must take the text label of G5
In sheet 5: When I take G5 to a calculation in sheet 3 for example, the formula would look like this:
Sheet 3 D4=”Team A”*2 Therefore D4=85*2=170 therefore D4=170

If I can get the formula in sheet 3 to show the new label in the formula it would be easy for me when I come back to the estimate in a few weeks’ time to understand my thinking.
Other calculations may look like the following:

In sheet 3: E4=”Team A”+”Team B”

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Replies
7
Views
123
Replies
4
Views
210
Replies
3
Views
62
Replies
9
Views
59
Replies
1
Views
144

1,129,307
Messages
5,635,456
Members
416,858
Latest member
yelofneb

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back