GuruOfComputerWisdom.com

Excel - reverse vlookup from bottom up. Love this, hard to find!

This will return the last match, assuming your lookup value is in A1 and your return results are contained in column D….change as necessary. =LOOKUP(2,1/($C$1:$C$5201=A1),$D$1:$D$5201)

This is like using a vlookup from the bottom up.

Original Article

10/03/11

Woman brings a duck to Vet. Vet says, Your duck is dead. Woman says, Are you sure? Yes, says Vet. How can you be sure you’ve done no tests. Vet brings in a Labrador retriever which sniffs the duck and shakes his head. Next, a cat which sniffs the bird and shakes its head. Vet says, Sorry, but as I said your duck is dead. Vet hands woman a bill. She cries, $820 to tell me my duck is dead! Vet says, If you had taken my word for it the bill would be $20 but Lab Reports and Cat Scans cost extra..

09/13/11