I need help on a lookup formula, if possible not VBA.
Here is the requirements:
On Sheet 1 If I put 5% on A1 and PR on B1, then C1 should be return 0.26, this should be based on the table on sheet 2 as shown below.
<tbody>
</tbody>
Here is the requirements:
On Sheet 1 If I put 5% on A1 and PR on B1, then C1 should be return 0.26, this should be based on the table on sheet 2 as shown below.
Pages Split %age | CD | PR | QC | LT |
0% | 0.27 | 0.24 | 0.15 | 0.36 |
5% | 0.30 | 0.26 | 0.16 | 0.39 |
10% | 0.32 | 0.28 | 0.17 | 0.43 |
15% | 0.34 | 0.30 | 0.18 | 0.46 |
20% | 0.37 | 0.33 | 0.19 | 0.49 |
25% | 0.39 | 0.35 | 0.20 | 0.52 |
30% | 0.41 | 0.37 | 0.21 | 0.55 |
35% | 0.44 | 0.39 | 0.23 | 0.58 |
40% | 0.46 | 0.42 | 0.24 | 0.61 |
45% | 0.48 | 0.44 | 0.25 | 0.64 |
50% | 0.51 | 0.46 | 0.26 | 0.67 |
<tbody>
</tbody>
Last edited: