The file named Casesensitive.xlsx contains product codes and product prices. Note that the product codes are case sensitive. For example, DAG32 is not the same product as dag32. Write a formula that gives the product price for any product code. Hint: You might need to use the EXACT function. The formula EXACT(cell1,cell2) yields True if cell1 and cell2 have the same contents. EXACT differentiates between uppercase and lowercase letters.

Transcribed Image Text:

KIS 1 2 3 4 5 6 9 10 11 12 13 14 15 16 17 18 D E Code Ar12 ba14 cat12 dog32 az12 Cat12 DAG32 Price 1 2 4 5 9 2 H