How to highlight selected cell in excel

Recently I received a question from our reader through our facebook page about how to highlight selected cell in excel with color. I have crated this short VBA codes for following to answer his question: VBA code to highlight selected cell in a single sheet. VBA code to highlight selected cell in all sheets VBA … Read more

Lookup case sensitive match with EXACT function

Lookup case sensitive

There are many methods to lookup case sensitive match, but in this article we will discuss array function with INDEX MATCH with EXACT function. In the below table, same name Deep Singh is repeated with small case. If we apply Vlookup formula, in both cases it will return first match without considering the case sensitivity. … Read more