
Fortunately, the EXACT function will do this. The twist in this case is that we need to check every value in the Color column against the value in F5. If the two values match exactly, EXACT returns TRUE. The EXACT function is designed to perform a case-sensitive comparison of two text values.

#Vlookup in excel 2016 by color how to#
In the following post, we are going to illustrate how to returnthe minimum using a simple example. However, there are situations in which you need to get the minimum under a condition. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version.

However, to enable a case-sensitive VLOOKUP, we can't use the existing table as-is, and this means we need to take special steps to assemble a table that will work for this problem. Unlike XLOOKUP or INDEX and MATCH, VLOOKUP requires the entire table be provided in the table_array argument. The second challenge is the table itself. VLOOKUP matches "Red" in row 3, and returns 17, even though the lookup value is "RED" in uppercase.

= VLOOKUP ( "RED" ,data, 3, 0 ) // returns 17
