I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!



Sometimes unexperienced Excel © users apply a Match or Vlookup worksheet function with a last parameter True or 1 (this is the comparison type), but their lookup area is not sorted ascending.

The UDF below is checking this. If you are interested in testing with worksheet functions, join my little challenge at LinkedIn, group Advanced Excel and VBA.

Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download