I have a formula that I’ve used successfully in MS Office.

```
=IF($E5="","",(LOOKUP(2,1/(startYear<=$E5)/(endYear>=$E5),sinclairA)))
```

Where startYear, endYear, and sinclairA are named ranges on a separate sheet. This formula does not seem to work in Calc.

I am looking for the value in a row (sinclairA), if that year falls between two other years. For example, B2 is 2013 and C2 is 2016. If the year we are looking at is 2015, the formula should return the value in D2 (sinclairA).

Any idea how I can do this in Calc?

Thanks in advance