Use the EXACT function to compare cell values, including upper and lower case. Get the links on my Contextures website: http://www.contextures.com/podcasts/pc20170518.html