Catalyzes the reduction of isatin, 4-oxonon-2-enal, 9,10-phenanthrenequinone, menadione, 2,3-hexaenadione, 3,4-hexanedione and 2,3-heptanedione. a secondary alcohol + NADP(+) = a ketone + H(+) + NADPH Belongs to the short-chain dehydrogenases/reductases (SDR) family.