The best way to enforce a case sensitive search in Excel is to use the INDEX / MATCH combo as follows.
If your original formula is:
then use the following:
Thanks to MrExcel
See also http://blog.contextures.com/archives/2009/10/16/case-sensitive-lookup-in-excel/ especially the alternatives in the comments.