Index Seek on SQL Server
You are correct in your description but the conclusion is not correct.  It may still be faster to use the index anyway even if it has to go off to the table for the rest of it.  The data pages contain many fewer rows than the index so there's lots of extra I/O when scanning.  Generally the index will tend to give you benefits if it selects few rows even if it's not a great fit.