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!

 

sbMatchCheck

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.

sbMatchCheck_01_Screen
sbMatchCheck_01_Code
sbMatchCheck_02_Code
Sulprobil   Get it done   Contact   Disclaimer   Download