Daniel Hutmacher answers a question:
Can SQL Server piece together two different indexes in a single-table query, rather than just giving up and scanning a suboptimal clustered index? The short answer is: yes, in a fairly narrow band of conditions.
The actual answer is a lot more restrictive than you might initially think.