In a lookup table, how can you get Excel to find the item that’s the exact match, including the upper and lower case?
For example, in this table, row 4 is M7 and row 5 is m7. There’s a different value for each of these in column B. If I do a lookup for m7, I [...]