WjmExcelHelp
New Member
- Joined
- Mar 25, 2019
- Messages
- 4
Could someone please help me with a formula for excel?
What I need to do is compare cell A1 with column B1:C4 and when there is a match or the figure is between the numbers, it should show the number in cell C, but this will be on another sheet called sheet 2
Sheet 1
<tbody>
</tbody>
Sheet 2
If Sheet 1, A1 falls between B2 and C2 then Sheet 2, A1 must show Sheet D2
<tbody>
</tbody>
Please help me with a formula for sheet 2 A1
What I need to do is compare cell A1 with column B1:C4 and when there is a match or the figure is between the numbers, it should show the number in cell C, but this will be on another sheet called sheet 2
Sheet 1
| A | B | C | D |
1 | R165 000.00 | R0.00 | R100 000.00 | 15 |
2 | | R100 000.01 | R200 000.00 | 10 |
3 | | R200 000.01 | R300 000.00 | 7 |
4 | | | | |
<tbody>
</tbody>
Sheet 2
If Sheet 1, A1 falls between B2 and C2 then Sheet 2, A1 must show Sheet D2
| A | B | C | D |
1 | 10 | | | |
2 | | | | |
3 | | | | |
4 | | | | |
<tbody>
</tbody>
Please help me with a formula for sheet 2 A1