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>
A
B
C
D...