Hello,
[Sheet 1]
<tbody>
</tbody>
[Sheet 2]
<tbody>
</tbody>
What I am trying to do is fill out the last column on [Sheet 1]. I need to look at every row in [Sheet 1] at the [Number] field and determine whether or not that number falls between any of the ranges in [Sheet 2]. So, as you can see number 894 is found between 880 - 990, that is why we have a 'Y'; however number 12354 is not found between any of the ranges on [Sheet 2]; so the answer is 'N'. What formula do I put in D2?
[Sheet 1]
Type | Number | Item | Is this number within Range? |
Red | 12354 | Apple | N |
Red | 6549866 | Orange | N |
Green | 13216 | Apple | Y |
Blue | 894 | Banana | Y |
<tbody>
</tbody>
[Sheet 2]
Start | End |
123 | 129 |
880 | 990 |
13200 | 13300 |
8979 | 8980 |
<tbody>
</tbody>
What I am trying to do is fill out the last column on [Sheet 1]. I need to look at every row in [Sheet 1] at the [Number] field and determine whether or not that number falls between any of the ranges in [Sheet 2]. So, as you can see number 894 is found between 880 - 990, that is why we have a 'Y'; however number 12354 is not found between any of the ranges on [Sheet 2]; so the answer is 'N'. What formula do I put in D2?