I am trying to do the following:

```
one sheet | in another sheet
-----------------------------------
C | R S
448 | 497 517
| 526 542
453 | 812 814
```

can I check if C is between any value in all lines for R and S and then perform an operation if is it true?

an example for if `=if(C(1)<=R(:)&&C(1)>=S(:))`

`c`

is between any two values in a`row`

of RS or a`column`

of RorS? – Raystafarian Jul 15 '13 at 12:29