vrblakelock
New Member
- Joined
- Jul 9, 2012
- Messages
- 4
Hi,
Sheet 1 has a number [Column A]. i am after a formula that looks that number up in sheet 2, see's if it is within the range, and returns the 3rd column of that row.
See below for sheet contents
Sheet 1
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks
Vince
Sheet 1 has a number [Column A]. i am after a formula that looks that number up in sheet 2, see's if it is within the range, and returns the 3rd column of that row.
See below for sheet contents
Sheet 1
A | B | |
1 | Daily Occupied Head Count | LEVEL |
2 | 201 | |
3 | 109 | |
4 | 300 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
Minimum | Maximum | Level |
0 | 200 | level 1 |
201 | 250 | level 2 |
251 | 325 | level 3 |
326 | 400 | level 4 |
401 | 500 | level 5 |
501 | 600 | level 6 |
601 | 700 | level 7 |
701 | 800 | level 8 |
801 | 1000 | level 9 |
1001 | 10000 | level 10 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks
Vince