When vlookup fails
Having leading or trailing spaces around text is one of the most common reasons why vlookup fails. The solution to this problem is simple: the trim function. Trim removes spaces from around text. Wrapping the lookup_value and the table_array inside the trim function makes vlookup much more sturdy. Trim operates on one value at a […]
