THolzschuh
New Member
- Joined
- Mar 28, 2017
- Messages
- 3
Hello - I am new to the forum and hoping that someone can provide guidance on how to write a formula that would would include an IF and Vlookup. I'm not sure if this is the best approach to the formula required but that's were my mind is at.
Below is what I'm faced against. I'm trying to determin the # of manhours it would take based on the level (OLT or ILT) and have the result of man hours pulled from the chart. For example: The level is OLT and the outcome level is 1.2. I would want the manhours to pull from the chart below and the answer returned should be 218. However, if the Level was not OLT but instead ILT I would want it to return the number manhours of 200
<TBODY>
</TBODY>
Below is what I'm faced against. I'm trying to determin the # of manhours it would take based on the level (OLT or ILT) and have the result of man hours pulled from the chart. For example: The level is OLT and the outcome level is 1.2. I would want the manhours to pull from the chart below and the answer returned should be 218. However, if the Level was not OLT but instead ILT I would want it to return the number manhours of 200
A | B | C | D | |
1 | Outcome Level | 1.2 | ||
2 | Level | OLT | ||
3 | Manhours | formula needed here | ||
4 | ||||
5 | Outcome Level | ILT | OLT | |
6 | 1.0 | 165 | 181 | |
7 | 1.1 | 182 | 200 | |
8 | 1.2 | 200 | 218 | |
9 | 1.3 | 208 | 237 | |
10 | 1.4 | 233 | 256 |
<TBODY>
</TBODY>