In 'The Red-Headed League' by Arthur Conan Doyle, Sherlock Holmes investigates a peculiar job offer made exclusively to red-headed men. When the job suddenly disappears, Holmes and Dr. Watson uncover a deeper plot involving a criminal scheme. Using his sharp deductive skills, Holmes unravels the mystery, leading to a surprising and clever resolution.