We have a list of products. Products have variants, one with uppercase letters and the other with lower case letters. We want to lookup a product code to return sales data. VLOOKUP would ignore the difference in case so how do we solve this problem?

We can use the EXACT function which compares text values include case.
------------------------