I am attempting to create a formula for selecting the correct labor hours for a piping project...there are 4 criteria that have to be met or matched in order for the correct labor to be selected...(size, sch, mtl shop/fld,)...an abbreviated version of the table is as below...
<tbody>
</tbody>
Ideally what I would like to happen, on a different worksheet, is to create a formula in a cell, that says, for example, if size=36, sch=std, mtl=cs, shop/fld=s then labor (in that cell) =18 ...is there a function in excel that will determine that all criteria has been met and select the correct labor figure...any help would be appreciated....thanks
SIZE | SCH | MTL | SHOP/FLD | LABOR |
36 | STD | CS | S | 18 |
30 | STD | CS | S | 12 |
26 | STD | CS | S | 9.5 |
36 | XH | CS | S | 32 |
30 | XH | CS | S | 18 |
26 | XH | CS | S | 12.5 |
36 | 10S | SS | S | 140 |
30 | 10S | SS | S | 125 |
26 | 10S | SS | F | 100 |
<tbody>
</tbody>
Ideally what I would like to happen, on a different worksheet, is to create a formula in a cell, that says, for example, if size=36, sch=std, mtl=cs, shop/fld=s then labor (in that cell) =18 ...is there a function in excel that will determine that all criteria has been met and select the correct labor figure...any help would be appreciated....thanks